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
Printable View
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
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
Quote:
Originally Posted by tabreaz
In first method u specified, does the output need to be spooled ??
of course it does
Perhaps it is worth mentioning that "spool" is a SQL*Plus command.
Tom Kyte (of course) has some solutions:
http://asktom.oracle.com/~tkyte/flat/index.html