Re: HELP!!!! Strange select statement output

If you are using SQL*PLUS:

col f_docnumber format 999999999999
select f_docnumber from doctaba;

Will format the number as you want.

Kenny Gump
OCP 7.3 DBA

Chris Reddy wrote in message <7dbprb$lbt$1_at_news-1.news.gte.net>...
>Hi All,
>
>I'm performing a select statement on a database and the field that I am
>querying on contains a numeric value in the billions, and my output is
>displayed in scientific format.
>
>select f_docnumber from doctaba
>
>The return output is:
>
>3.000E+09
>3.000E+09
>3.000E+09
>
>I want to view the number which would be
>3000002254
>3000002255
>3000002256
>
>What is the select condition I need to use in order to view the number how
 I
>want.
>
>I am stumped.
>
>Any help would be greatly appreciated.
>
>You can e-mail me at iiidana_at_ix.netcom.com or post to the group.
>
>Thanks in advance,
>
>Chris Reddy
>
>
>
>
>
>
>
Received on Thu Mar 25 1999 - 00:00:00 CET