SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Leading Zeros & Exporting to CSV

sliderrulesJan 8 2015 — edited Jan 8 2015

Hi,

I am running a sql query that extracts telephone numbers and when exported to csv the 0's are dropped. I understand this is an excel formatting problem, however is there any work around in the SQL that can retain the leading zeros when exported to csv?

This post has been answered by Marwim on Jan 8 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2015

Added on Jan 8 2015

14 comments

6,205 views