| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How to dump all tables belong to a user into multiple flatfiles
Mark,
I want the final .sql to look like this.
spool member.txt
select ltrim(rtrim(username)), ltrim(rtrim(id)), blah...
from member;
spool off
spool tab2.txt
select ltrim(rtrim(col1)), ltrim(rtrim(col2)), blah...
from tab2;
spool off
It's a little harder to achieve than selecting all cols using *.
Allan W. Tham Received on Sat Sep 07 2002 - 08:49:49 CDT
 |
 |