| reg UTL_FILE [message #70704] |
Tue, 16 July 2002 04:27  |
mani
Messages: 105
Registered: September 1999
|
Senior Member |
|
|
hai ...
am using oracle 8i.i have one table with 400 columns.i need to export the table data to a flat file.
here i cant use UTL_FILE as it has a limitation of 1022 bytes.i cant use sql loader also.how can i get rid of this???
Is there anyway of using UTL_FILE utility for outputting a query results into flat file in a single shot...
thanks in advance
mani
|
|
|
|
|
|
| Re: reg UTL_FILE [message #70755 is a reply to message #70704] |
Sat, 20 July 2002 01:53  |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
spool sunil.lst
select ename||' '||address||' '||phono;
spool off
get the file sunil.lst, which will contain the test seperated with spaces
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
