Home » Applications » Oracle Fusion Apps & E-Business Suite » Concurrent program writing in excel file automatically removing leading zeros (Oracle 11i)
Concurrent program writing in excel file automatically removing leading zeros [message #383458] Wed, 28 January 2009 23:53 Go to next message
rmasurka
Messages: 5
Registered: October 2008
Location: Bangalore,India
Junior Member
Hi,
I have a concurrent program who's executable method PL/SQL stored procedure.Output of this concurrent program is in the form of Excel file.The problem which I am facing is, in the Excel file leading zero's is automatically removed by Excel. I supposed it is due to Excel automatically formatting cells and we don't have any control on Excel output through concurrent program.Though I have solved this problem with some workaround but How can I solve this problem in PL/SQL coding.

Regards,
Roshan

[Updated on: Wed, 28 January 2009 23:55]

Report message to a moderator

Re: Concurrent program writing in excel file automatically removing leading zeros [message #384496 is a reply to message #383458] Wed, 04 February 2009 02:00 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
hi,
try by to_char to clumn and check....


Kittu.
Re: Concurrent program writing in excel file automatically removing leading zeros [message #384511 is a reply to message #383458] Wed, 04 February 2009 02:52 Go to previous messageGo to next message
rmasurka
Messages: 5
Registered: October 2008
Location: Bangalore,India
Junior Member
I already checked with to_char it not working
Re: Concurrent program writing in excel file automatically removing leading zeros [message #384512 is a reply to message #383458] Wed, 04 February 2009 02:52 Go to previous message
rmasurka
Messages: 5
Registered: October 2008
Location: Bangalore,India
Junior Member
I already checked with to_char it's not working
Previous Topic: How to automatic mail at specific time
Next Topic: CALENDAR
Goto Forum:
  


Current Time: Thu Dec 05 06:49:48 CST 2024