newbie question

From: Lance Nguyen <ap882_at_torfree.net>
Date: Sun, 5 Jul 1998 19:53:39 GMT
Message-ID: <Evn0LG.8BL.0.bloor@torfree.net>

Hello Gurus,

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?

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?

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

Are there any books out there that answers these questions?

Are there any web sites on the internet that will give a newbie some basic and advanced tutorials?

Thanks in advance
--
--

Lance Nguyen
ap882_at_torfree.net Received on Sun Jul 05 1998 - 14:53:39 CDT