Here i am going to share about how we can create simple user and table in Oracle 10g database.
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....
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