How to make Table in Oracle ?

Question

Hi How I can make my Table in Oracle 10G ? in graphically - like in Sql server

thank's in advance

Answer 1

I expect you are looking for Oracle SQL Developer

Answer 2

Use Oracle's Enterprise Manager. From the command line, type:

emctl status dbconsole

This will give you the URL. Put that URL in your browser. Login with sys as dba. Then go to Schemas > Tables > Create.

Answer 3

In addition to HermanD's suggestion, there is a popular tool called TOAD. However, it costs a boatload.

SQL Developer is free, but you have to have Java installed and it locks up sometimes. Also, it doesn't give the Oracle error message all the time, failing silently. In those cases, I have to fire up TOAD to get the error message. All that said, I find SQL Developer to be more intuitive than TOAD. TOAD is dependent upon the local installation of the Oracle client, TNSNames and such, whereas SQL Developer has its own client bundled in.

You can download the JVM as a bundle when you download SQL Developer.

Oh yeah, and don't forget about ERwin. ERwin will let you develop your entire schema graphically, then it'll give you DDL statements to paste into SQL*Plus/SQL Developer/TOAD. If you already have a schema, ERwin will reverse engineer it for you by reading your table structure and FKs.

(Most of this would be a comment but I don't have 50 rep yet.)