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 a query to csv file

866252Jun 2 2011 — edited Jun 2 2011

Here is the sql query I am running

SELECT * FROM analytics.BOS_RT_TP_GT_PR_FINAL WHERE TMC like '129N04774' ORDER BY LOCAL_DATE

after I run the query I then am right clicking on the table, going to export, setting the file to a csv and the directory to c:/temp/tmcs/129N04774.csv then running that

is there a way I can write an export command directly into the code so I don't have to click and go through the gui each time?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2011

Added on Jun 2 2011

#export, #oracle, #sql

2 comments

314 views