Re: do desc on tables, dump output to text file

On 18 Nov, 15:03, "Joey.Dant..._at_gmail.com" <Joey.Dant..._at_gmail.com> wrote:
>
> There is the ever popular:
>
> set hea off
> set echo off
> spool scriptfile.sql
> select 'spool reportfile' from dual;
> select 'desc '||table_name||from dba_tables where owner='$OWNER';
> spool off
> @@scriptfile- Hide quoted text -
>

Slight typo, the last line should read:

select 'desc '||table_name||from dba_tables where owner='&OWNER';

Note: "&" instead of "$".

Or, the following line before the SPOOL and the first SELECT would also work:

SET DEFINE $ HTH -g Received on Tue Nov 18 2008 - 09:54:50 CST