Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Table documentation

Re: Table documentation

From: BILL M COHEE <COHEEB_at_prodigy.net>
Date: Wed, 12 Aug 1998 00:52:44 -0400
Message-ID: <6qr6bl$dpnm$1@newssvr04-int.news.prodigy.com>


This might work:

select 'desc' || table_name from all_objects where object_type='TABLE' ;

Bill in NY

Corinna Becker wrote in message
<01bdc509$eee05a20$a049100a_at_pc743-sode.seurope.ikea.com>... Hello,
I want to write a documentation of all our tables by using the desc command.
Is there a way to do something in SQLPLUS like "desc (all tables that we have)"?
Thanks in advance
Corinna Becker Received on Tue Aug 11 1998 - 23:52:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US