Thursday, 17 January 2013

How to Create Table in Oracle 10g using Browser

Here i am going to share about how we can create simple user and table in Oracle 10g database.

Step 1:
         Download and Install Oracle 10g.

Step 2:
         In Installation folder you have to find "Go to database Home Page" html file..
         Normally it Located at  "C:\oraclexe\app\oracle\product\10.2.0\server"

Step 3:
         Now Click that html file

Step 4:
         Now give username as "system" and give your password (what you given in during installation)

Step 5:
         Now Select Administrator Icon ->Database Users ->Create User


Step 6
         Now Give new Username, Password and select Account Status in unlocked, Select all the Check     boxes in Roles.
         Now Click Create..




Step 7:
         New user has been created. Now logout from Oracle and again Sign in to oracle with new username

Step 8:
         Now Choose Object Browser -> Create -> Table




Step 9:
         Give table name and Column name..
         Click next if you want to create Key. You can create here. finally click create button.





Step 10:
         now new Table has been created,, In Same window you can see Data tab.. here you can add data into table.

Thanks for Visiting....



No comments:

Post a Comment