Video is ready, Click Here to View ×

Refer Complete Tutorial :

Create Oracle Database Tables Using GUI SQL developer Tools

• Create Orale tables using Oracle SQL Developer

Creating Oracle Tables .
1. Oracle database required:
DNS Name : xxxxxxxxx
User Name: haneef
Password : xxxxxxxxxxxxxxx
Service Name : Haneef

2. Software Required :
Oracle SQL Developer ( this requires JDK )
Link to Download :

Create two tables.
1. Employee
2. Department

Employee Table :
• Employee ID ( Primary key)
• Employee Name
• Employee Department
• Employee Salary

Department Table:
• Department ID (Primary key)
• Department Name
• Department Head

Create Foreign Key For Employee Department to get ID from Department Table.

Create DDL and Execute them.