Displaying large numbers in Toad for Oracle 10.6

Toad for Oracle
1

I am running a script that creates a table with several fields. One of theose fileds contains a 12 digit number field. I am pulling this field directly from a source table - i.e no calculations

The script output always displays this field in scientific notation, even when I “uncheck” the “Display large numbers in Scientific notation” button in the “Toad options” screen.

Is there a way to force it to display a 12 digit integer?

2

Hi
When runing as script, Toad is trying to behavie like SQLPlus. And here is how SQLPlus acts:

SCOTT@XESSD> select 12345678901234 x from dual;

     X

1,2346E+13

SCOTT@XESSD> col x format 999999999999999999999999990
SCOTT@XESSD> /

                       X

          12345678901234

SCOTT@XESSD>

Cheers,
Damir

3

would this be the syntax? I can’t get it to run

select distinct

…,

column r.ASSIGNMENT_ID format 999999999990 as “Assignment ID”,

…

from

…

4

If running as script…

col Assignment ID format 999999999999999999999999990

Select r.ASSIGNMENT_ID “Assignment ID”,

from…

If you run with F9 then you don’t need to include the COL commands. The Scientific Notation option will handle that for you.

5

Oops I forgot to add the double quotes. Here is a working example.

col “Assignment ID” format 999999999999999999999999990

Select 12345678909876543 “Assignment ID”

from dual;

6

That worked, but I had to put double quotes around the column name in the col statement like this:

col “Assignment ID” format 99999999999990

select distinct

…

I am running as script and the scientific notation ooption did not work, unless I am misunderstanding how to use it.

7

Does using “f9” differ from using the “Execute as Script” icon?

8

Yes, F5 is for running scripts, multiple statements in the editor, emulates SQL*Plus. F9 is for running single statements/compiling

From: Mark J [mailto:bounce-Mark_J@toadworld.com]

Sent: Thursday, April 02, 2015 11:11 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Displaying large numbers in Toad for Oracle 10.6

RE: Displaying large numbers in Toad for Oracle 10.6

Reply by Mark J

Does using “f9” differ from using the “Execute as Script” icon?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

9

Thanks, I always use the icon on the desktop for scripts