-
Table contents to flat file
hi,
What is the best way to write the Oracle table contents to Flat file ?
Is there any tool provided by oracle for the same
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
There are few ways to accomplish your requirement:
through SQL statment
Select col1 || ',' || col2
from <>
secondly
through PL/SQL procedure using UTL_FILE package
Through PL/SQL u can have better control on formating
-
Originally Posted by tabreaz
There are few ways to accomplish your requirement:
through SQL statment
Select col1 || ',' || col2
from < >
secondly
through PL/SQL procedure using UTL_FILE package
Through PL/SQL u can have better control on formating
In first method u specified, does the output need to be spooled ??
------------------------------------------------------------------------
The most enjoyable things in the world are either Immoral or too Expensive or otherwise Inaccessible anyway
-
-
Perhaps it is worth mentioning that "spool" is a SQL*Plus command.
Last edited by WilliamR; 06-28-2006 at 02:28 AM.
-
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|