Re: SQL*Plus
Date: 10 Jun 1993 09:50:41 -0500
Message-ID: <C8Eu7K.4Ey_at_uk.ac.brookes>
Paul Krikorian (paulk_at_spock.dis.cccd.edu) wrote:
> Hello everyone,
> I have another SQL*Plus question. We are in the middle of our first
> Oracle project and the database is changed occasionally. I like to work
> from a printed copy of all the tables while I'm writing my PRO*COBOL
> program. The 'DESCRIBE' command in SQL*Plus works great for detailing one
> table, but since our database has over 40 tables, it is a pain printing
> all the tables at once.
I always cheat:
SPOOL desc_table.SQL
SELECT 'DESCRIBE '||TNAME FROM TAB WHERE TABTYPE='TABLE';
SPOOL OFF
START desc_table
(with apologies for using TAB, but I never bothered looking up what I
should be using, since TAB works)
It needs a bit of tidying up to remove errant SQL> prompts etc. but...
-- _________________________ _________________________________________ / Tommy Wareing \ / And I dream of movies \ | p0070621_at_uk.ac.brookes X They won't make about me when I'm dead | \ 0865-483389 / \ - Jon Bon Jovi, Keep the Faith / ~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Thu Jun 10 1993 - 16:50:41 CEST