Home -> Usenet -> comp.databases.oracle -> re: List All Tables

re: List All Tables

From: Bob Treumann <btreuman_at_empros.com>
Date: Thu, 9 Dec 1993 18:12:06 GMT
Message-ID: <CHs586.AtK_at_empros.com> 






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
Received on Thu Dec 09 1993 - 19:12:06 CET












Original text of this message