Re: GUI tool for view tabels, triggers ect.
Date: Sun, 24 Feb 2002 22:07:34 -0400
Message-ID: <a5c9r5$d40$1_at_bob.news.rcn.net>
If you dont want to spend taxpayer money dont get the GUI. It is totally unnecessary. Learn the data dictionary. It is clearly described in the free documentation.
You can get EVERYTHING you need out of it with a little practice. If your students need to learn Oracle it is essential that they learn the data dictionary.
This is what you do to get started. Do the following query...
Select VIEW_NAME
FROM ALL_VIEWS
WHERE VIEW_NAME LIKE 'ALL_%';
This will give you a basic list of views. You can also do user_ and dba_
To get table info use all_tables and all_all_tables. To get column use
all_tab_columns and
all_cons_columns
Then do describes. You do NOT need a GUI. In a few days you can get the hang
of it and your students will learn alot.
"Kurt Bilde" <kub_at_sam.sdu.dk> wrote in message
news:3C73B389.9080609_at_sam.sdu.dk...
> Hi !
>
> Does anyone know a GUI tool for Oracle 9i for viewing data in tables,
> triggers ect.?
>
> Also do you know a GUI-tool for Imp/exp for Oracle 9i?
>
> -Kurt
>
Received on Mon Feb 25 2002 - 03:07:34 CET