Re: please, help me...

On Sun, 15 May 2005 10:21:12 +0200, Luca interested us by writing:

> thank you, but I remember that Oracle8 (or 9) have a quite simple gui: we
> didn't write code in a command line.
> After login to an oracle server I remember that there were an interface with
> a menu in a left column. I this menu you found the way to create tables,
> views, trigger, administrations tools an other stuff.
> I know sql sintax to write a "create" or "select" instruction, but if I need
> to create a schema with more than 20-30 tables. with many attributes, if I
> use the command line I'll finish this work next month!

To the best of my knowledge, no version of the Oracle database has (or has had) a built-in GUI tool like you describe. Oracle profesionals very quickly get familiar with SQLPlus and the command line; conversely, a lack of good knowledge of SQLPlus frequently causes long-term problems because GUI's generally assume a certain way of doing things and are rarely as flexible as command line.

However, since Oracle8 (and therefore Oracle8i DB, Oracle9i DB and Oracle DB10g) Oracle has supplied the Oracle Enterprise Manager which does have a limited, and moderately simplistic GUI similar to what you describe. With Oracle Database 10g, the Enterprise Manager is now a browser-based tool that you access from the browser.

One other possibility is to add Oracle JDeveloper 10g to your toolkit. Under the System Navigator, you have the ability to define Connections and a Conection to the Oracle database includes a limited ERD tool, a limited GUI for creating and managing Oracle objects, and a PL/SQL debugger.

As Sybrand said - read the Getting Started Guide. I also encourage reading the Concepts manual and the Database Administrator's Guide and the Oracle Enterprise Manager Concepts.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***