Home » SQL & PL/SQL » SQL & PL/SQL » Oracle to Excel - Display problem! (Oracle 9i.)
Oracle to Excel - Display problem! [message #325825] Mon, 09 June 2008 01:55 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi all,

I have generated an excel file from oracle which will have ID & Name as 2 coloumns.

In this ID column defined as CHAR, field values will be Alphanumeric. When i display the result in excel sheet its showing 3.5E + 11 .. scientific notation. But my client need it as number.

I tried using TO_NUMBER, since its alphanumeric, it doesnt work!
I tried using TO_CHAR, that too not working..

Is there anyway to overcome this problem?

thiyagarajan palanisamy
Re: Oracle to Excel - Display problem! [message #325831 is a reply to message #325825] Mon, 09 June 2008 02:21 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Enclose your output string value with "

Regards
Michel
Previous Topic: Execute Immediate Statement with the procedure that contain OUT Mode parameter
Next Topic: How to get source code for the materalized view created
Goto Forum:
  


Current Time: Sat Dec 03 16:33:12 CST 2016

Total time taken to generate the page: 0.09289 seconds