| sql developer querry [message #273970] |
Fri, 12 October 2007 07:51  |
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  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
1) All you have to do to get | delimited output is toSELECT 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
