CODEWITHSUNDEEP
sqloracle-databaseoracle-sqldeveloper
Keithx
Keithx

Reputation: 3148

Scheduled export from SQL Developer

I have a need to export the data from the table into .csv file and do it schedulled. I've not work much on SQL developer before, mainly on SQL Server. So what options do i have to do this auto export?

Upvotes: 1

Views: 8529

Answers (3)

thatjeffsmith
thatjeffsmith

Reputation: 22427

SQL Developer has a command line interface, SDcli - you'll find it in your SQL Developer BIN directory.

You can build a 'cart' in the SQL Developer GUI, and save it to a file. This cart's contents are database objects, including tables.

enter image description here

You can ask to export the contents of your cart to various file formats, including CSVs for the data.

Here's what the CLI looks like

enter image description here

Detailed example here.

Upvotes: 3

vishad
vishad

Reputation: 1164

Oracle SQL developer does not have the feature to do schedule export of the dataset. You will need to write a PL/SQL code using UTL_FILE/ SPOOL and schedule it using either Oracle Scheduler or some other Scheduling tool.

Hope it helps

Vishad

Upvotes: 0

vasja
vasja

Reputation: 4792

As a Powershell fan, I'd point your attention to this tutorial.

Though SQL Developer not involved.

Upvotes: 0

Related Questions