Skip to Main Content

Oracle Database Discussions

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!

unload tables to text file with delimiter ;

265441Sep 11 2011 — edited Sep 12 2011
I want to dump all the data from table into a text file with ; as a delimiter without applying a || ; || between fields. Is there a ' select * from mytable' method;

And apply this to other tables.

Than want to run a script daily to ftp to other sources or keep as backup.

Thanks for you help.
This post has been answered by VenkatB on Sep 12 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2011
Added on Sep 11 2011
9 comments
3,939 views