Home » SQL & PL/SQL » SQL & PL/SQL » excel will read the vachar 1.10 as number when export from plsql
icon9.gif  excel will read the vachar 1.10 as number when export from plsql [message #206133] Tue, 28 November 2006 22:10 Go to next message
jaseloh
Messages: 3
Registered: December 2005
Junior Member
Hi ,


I had pull data in plsql and one of my field value is 1.10. When I open as excel file after export to csv, the value show in excel is 1.1. How can I still keep the format 1.10 in the output file? Any one can help me?


thanks for advance
Re: excel will read the vachar 1.10 as number when export from plsql [message #206176 is a reply to message #206133] Wed, 29 November 2006 01:15 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
1) why is this an expert question
2) why is this a SQL question (you posted this in SQL-Experts)
3) why is this an oracle question, since your pl/sql procedure wrote the correct output, it is EXCEL that needs tweaking.
Previous Topic: Executing procedure
Next Topic: Create new Trigger
Goto Forum:
  


Current Time: Mon Dec 05 06:46:01 CST 2016

Total time taken to generate the page: 0.06725 seconds