Re: command to list all user tables

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Thu, 13 May 2004 01:09:26 GMT
Message-ID: <aVzoc.35390$TT.24168@news-server.bigpond.net.au>

"David Wright" <David_wright_at_spra.com> wrote in message news:94E7B3B90Davidwrightspracom_at_64.164.98.50...
> anacedent_at_hotmail.com (Anna C. Dent) wrote in
> <U3zoc.124148$Jy3.85683_at_fed1read03>:
>
> >David Wright wrote:
> >
> >> OSCUQDVXTKFJ_at_spammotel.com (Thomas Kellerer) wrote in
> >> <c7u47f$775$1_at_svr7.m-online.net>:
> >>
> >>
> >>>David Wright schrieb:
> >>>
> >>>>>The Oracle Data Dictionary tables are documented in the Oracle
> >>>>>version# Reference manual. The is a dictionary view for every major
> >>>>>database object: table, view, synonym, indexes, constraints, etc....
> >>>>>
> >>>>
> >>>>I remember going to a bookstore and seeing a wall of Oracle books. Can
> >>>>you be more specific about the name of the SQL manual?
> >>>
> >>>I'm sure he meant the online manual available at http://otn.oracle.com
> >>>
> >>>Thomas
> >>>
> >>>
> >>
> >>
> >> I can't seem to find any help on the set commands or, more importantly
> >> the command delimiters for set commands. I suppose this is obscure.
> >
> >from http://tahiti.oracle.com/
> >
> >
> >to
> >
> >http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
> >
> >to
> >
>
>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm
> >
> >and
> >
>
>http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/toc.htm
> >
> >
>
> I think my problem is I have not been explaining myself properly. I mean
> documentation of such things like 'set spool off' or 'set spool
asdfasd.txt'.
> What is this language called? Is this PL/SQL? It seems to be a kind of
> scripting command. I didnt know that Oracle had other type of set
statements
> and then there are sql 'set' statements as in typical merge.

David,

These statements are documented in the "SQL*Plus User's Guide and Reference" (a90842.pdf) which is also at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/toc.htm .

The SET command is documented at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1011230 . This SET command controls the environment settings of SQL*Plus (or iSQL*Plus ). These products are used for the issuance of SQL commands from a terminal or a batch file.

Douglas Hawthorne Received on Wed May 12 2004 - 20:09:26 CDT