Re: List All Tables

From: Alvin W. Law <alaw_at_oracle.com>
Date: Fri, 10 Dec 1993 17:45:32 GMT
Message-ID: <ALAW.93Dec10094532_at_ap221sun.oracle.com>


In article <CHs586.AtK_at_empros.com> btreuman_at_empros.com (Bob Treumann) writes:
> This script should do it for you:
>
>
> rem !# Describe all tables for this user.
>
> set heading off
> spool temp.sql
>
> select 'DESC '||Table_name from user_tables;
> spool off
>
> set echo on
> spool tables
> start temp
> set echo off
>
> spool off

A much simpler and quicker way is to use another data dictionary view, namely USER_TAB_COLUMNS.

--
 Alvin W. Law .............................................. Oracle Corporation
 Senior Applications Engineer .................. 300 Oracle Parkway, Box 659306
 Manufacturing Applications .......................... Redwood Shores, CA 94065
 Email: alaw_at_oracle.com ........... Voice: 1.415.506.3390 . Fax: 1.415.506.7299
Received on Fri Dec 10 1993 - 18:45:32 CET

Original text of this message