From: "Sanjay D.S." <sanjay@fsg.prusec.com>
Subject: Re: Beginners PO7 Questions
Date: 1996/04/04
Message-ID: <4k1ci4$29i@prufire4.prusec.com>#1/1
references: <stacys-0204962148470001@pm1-s30.interpac.net>
to: stacys@interpac.net
content-type: text/plain; charset=us-ascii
organization: Prudential Securities Inc.
x-url: news:stacys-0204962148470001@pm1-s30.interpac.net
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 1.1N (X11; I; AIX 2)


stacys@interpac.net (R. Stacy Sherman) wrote:
>I just started learning PO7 (Macintosh) and have 2 questions:
>
>How do you see what tables are available?
>
>From what I've been able to get out of the docs, it seems that everything
>is all put together in one database.  Is this true?  Isn't there a command
>to create a new database?  

Use Following Sql statements to list tables.
1. To list all tables under your ORACLE account.
SQL>  select table_name from user_tables;
2. To list all tables that are accessible to you, but may be owned different
    ORACLE accounts.
SQL> select table_name ,owner from all_tables;
3. If you system password and list all tables created by all users, including
SYS, SYSTEM.
SQL > select table_name,owner from dba_tables;
4. To know your userid while logged onto sql*plus.
SQL> Show user
5. To list all objects (TABLE,VIEW,CLUSTER,INDEX)
SQL> select object_name,object_type from user_objects.

Get familiarized with data dictionary views like: USER_TABLES,USER_VIEWS,
USER_OBJECTs,USER_INDEXES. It will be pretty useful. Also In ORACLE create
database means different from creating tables. One ORACLE Database can hold
many different schema (database) objects.

Sanjay D.S.
Oracle Consultant
Prudential Securities, Inc.