Home » Other » Client Tools » sql developer querry (Exporting data to be scheduled)
sql developer querry [message #273970] Fri, 12 October 2007 07:51 Go to next message
DRASTANT
Messages: 21
Registered: July 2007
Location: KENYA
Junior Member
i have to do a certain data pullout in sql developer from my oracle data base is there any way that i can schedule this thing i have the qurey and every thing ready it has just to be excecuted and the data to be exported but automatically.

if not in sql developer is there any other tool or any other way i can achive this

i want the data in a pipe seperated values which is not avilable in sql developer so what do i do every time i have to export it to CSV and then replace the , with |


Any type of help will be appreciated
Re: sql developer querry [message #273976 is a reply to message #273970] Fri, 12 October 2007 08:55 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
1) All you have to do to get | delimited output is to
SELECT field_1||'|'||field_2||'|'||field_3....


2) To schedule a job in Oracle, you need to use DBMS_JOB or DBMS_SCHEDULER

How are you planning to export this set of data?
If you've set up a process using something like the 'Export' from SQL Developer then you're stuck doing this all by hand.
Otherwise, look at UTL_FILE
Previous Topic: TOAD - Compare Schema's - CLOB/BLOB
Next Topic: How can I view the Chinese data in my database?
Goto Forum:
  


Current Time: Thu Mar 28 19:11:58 CDT 2024