Re: HELP!!!! Strange select statement output

From: Chris Nelson <wrhs71_at_hotmail.com>
Date: 1999/03/26
Message-ID: <s7FK2.950$tQ5.3162_at_news7.ispnews.com>#1/1

Here is the simplest one-line solution that I have seen so far, and another follows:

1. Under Options, set NUMWIDTH to 10 (or more, whatever). The default is
2. You can do this within a SQL script with the command: SET NUMWIDTH 10

(The default is 9, which is why you can't see a 10 digit or higher number -- as a 'number' -- unless you specifically arrange for it to be displayed this way. Just setting:
COLUMN my_number FORMAT 9999999999
won't work.

2. You could also convert the number data to character format, and display any way you can think of (and which the commands and functions will allow), such as:
COLUMN my_number FORMAT A15
...
SELECT TO_CHAR( my_number, '999,999,999,999.') ...

Chris (newbies helping newbies)

Kenny Gump wrote in message <36fa7595.0_at_news.mountain.net>...
>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 Fri Mar 26 1999 - 00:00:00 CET