?? A way to set numeric format conversion for session ???

From: EnderW <ender29_at_my-deja.com>
Date: Mon, 13 Dec 1999 18:55:44 GMT
Message-ID: <833ffd$j77$1@nnrp1.deja.com>

Hi,
I don't know whether what I ask is possible or not. I am looking for a way to set the numeric format in printing numeric values. I am practically interested in setting a numeric format such as '0.999999'. Basically a "0" will be printed "0.000000". Is this possible as per session global value ? Or do I have to use a to_char conversion for each column I am selecting ? The next option is like death since I will be selecting more than 40 diff. possible column values. Thnx

--
Ender Wiggin

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 12:55:44 CST