Re: SQL*Plus

From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
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

Original text of this message