Re: script needed!

From: Gary M. Greenberg <garyg_at_southeast.net>
Date: 1997/02/15
Message-ID: <garyg-ya02408000R1502971450410001@news.southeast.net>#1/1

In article <3301189C.6259_at_ux1.cts.eiu.edu>, EIU #120154 IN LUMPKIN ROOM 034 <eiu120154_at_ux1.cts.eiu.edu> wrote:

> i need a script (in SQL) that will print out all attributes and tables.
> using oracle V7.

Untested:

select * from ALL_TAB_COLUMNS where exists(select table_names from ALL_TABLES);

? maybe,

gary         -=- visit The C Programmers' Reference -=-
          http://users.southeast.net/~garyg/C_ref/C/c.html
               The AVENUE Programmers' Class Requests
             http://users.southeast.net/~garyg/class.htm

Received on Sat Feb 15 1997 - 00:00:00 CST