Re: All column names
From: Alex Grutters <grutters_at_amis.nl>
Date: Wed, 05 Aug 1998 12:48:31 +0200
Message-ID: <35C8387F.BFE389EE_at_amis.nl>
Date: Wed, 05 Aug 1998 12:48:31 +0200
Message-ID: <35C8387F.BFE389EE_at_amis.nl>
An easy way would be in SQL*Plus:
set heading OFF
set pagesize 0
spool describe_tables.sql
select 'desc '||table_name from all_tables
spool OFF
and after some editing run the script describe_tables.sql
Henrik Wendt schreef:
> Hi
>
> Is there an easy way to describe all columns of all tables in the
> database ?
Received on Wed Aug 05 1998 - 12:48:31 CEST