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!

exporting to CSV

RaunaqApr 17 2015 — edited Apr 21 2015

I am on 11g

and i am exporting data to a CSV file using SPOOL command

i have 2 date columns and the date when exported to a CSV is not visible ( the seconds part)

its hidden in the same column even if i expand the column it does not appear , only after it we double on the cell in CSV the complete value displays

i am using to_char function with the data column

Any suggestions on how to get over this?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 19 2015

Added on Apr 17 2015

20 comments

1,022 views