Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB Schema

Re: DB Schema

From: <whatayno_at_aol.com>
Date: 1998/02/03
Message-ID: <34D76BED.A96@aol.com>#1/1

Well, a very general query can be
Select * from all_objects;

geetha_sanjeeviah_at_p-com.com wrote:
>
> Hi :
>
> I am new to Oracle, PL/SQL and Databases. I want to know the command in
> PL/SQL which I can enter from commandline, so that I can create a Dump
> file which gives me all the information about the various Schema objects
> like Tables, Views etc present in my Oracle 7 Database.
>
> Thanks
> Gita
>
> PS: Please direct all the replies to geetha_sanjeeviah_at_p-com.com
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Tue Feb 03 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US