Refer Complete Tutorial : [ Ссылка ]

Create Oracle Database Tables Using GUI SQL developer Tools

Tasks:
• 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.

свернуть