Create and Manage Oracle Database Using Oracle SQL Developer GUI
- Oracle SQL Developer
- Oracle Database Instance Login Details
Complete Video Tutorial
Install Oracle SQL Developer
Please note that in order to install Developer Tool you must have JDK 7 or above in your PC. If you do not have please download JDK from following link prior to downloading to SQL Developer tool.
Please make sure you have following details of Oracle DB is handy with you.
- Hostname :
- Username :
- Password :
- Service Name :
- Port No :
Step 3 :
Extract the Downloaded SQL Developer tools to a folder and open the file SQL Developer
This will Open Developer
Now Import Data Dictionary as shown
Enter the Oracle DB Details
Dont select any DB Tables as we are going to create new Tables
Now click Insert Table. Drag workspace to new table , enter table Name it as Employee and Click OK
Now Create Columns as Shown
Please note that Developer tool will not create the table automatically. We need to Generate the DDL and Paste it in the SQL workspace and execute for creating the tables .
Now copy the generated DDL