Skip to Main Content

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!

Creating excel files by extracting data from the database tables and transfer them to other FTP serv

HKumar679Aug 19 2016 — edited Aug 23 2016

Hi All,

We have PL SQL script which will create two tables with some data.  I need to export these two tables into Excel files and then transfer these files into STP server.

I need to amend the PL SQL script to automatically do the above steps without manual intervention.

Could you please guide/give me the generic script for this ?

Please let me know if you need any more details. I can't give the existing script due to working restrictions.

Regards

Kumar

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2016
Added on Aug 19 2016
25 comments
3,797 views