OraFAQ Forum: Client Tools » EXCEL preventing large numbers being displayed in scientific notation

Home » Other » Client Tools » EXCEL preventing large numbers being displayed in scientific notation

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXCEL preventing large numbers being displayed in scientific notation [message #475104]

Mon, 13 September 2010 01:08

raviraja
Messages: 1
Registered: September 2010
Location: Sydney

Junior Member

Here is one way to create EXCEL file from oracle sql query and
prevent excel displaying large numbers in scientific notation(exponential notation)

set feedback off
set verify off
set heading off

spool c:\excel_test.xls
select 'PO_NUMBER'||chr(9)||'VENDOR_NUMBER' from dual
union
select '=PROPER('||po_number||')'||chr(9)||'=PROPER('||vendor_number||')'||chr(9)
from invoices
where rownum < 12
order by 1 desc

Note that PO_NUMBER is 16 characters, VENDOR_NUMBER is 15 characters in invoices table.

Report message to a moderator

Re: EXCEL preventing large numbers being displayed in scientific notation [message #475109 is a reply to message #475104]

Mon, 13 September 2010 01:15

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

set numwidth 20

Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

[Updated on: Mon, 13 September 2010 01:16]

Report message to a moderator

Previous Topic:	Doubts on TOAD and SQL developer
Next Topic:	Unable ro run Explain Plan in Toad \|\| "toad explain plan statement_id too long"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:05:26 CST 2024