Re: newbie question

> How would I go about exploring the Oracle database that I newly have
> access to? All I know right now is how to 'sqlplus' and run some
> sql statements to query some tables that I know exists. How do I find
> what other tables exists in the database?

Your tables:
select table_name from tabs;
Other tables:
select table_name from dba_tables;

> Also suppose, that I was told a certain trigger (say triggerA) is
> associated with a table (say TableA). How would I view/edit this
> so called trigger? Is there a table somewhere that lists all the
> available trigger in the database?

select object_name from user_objects where object_type = 'TRIGGER';

> As a matter of fact, what are some system tables that oracle use to
> maintain the rdbms?

dba_tables, all_tab_columns

> Are there any books out there that answers these questions?

Oracle - The Complete Reference
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.) Received on Tue Jul 07 1998 - 10:59:48 CDT