Video is ready, Click Here to View ×


Refer Complete Tutorial : http://haneefputtur.com/create-manage-oracle-database-using-oracle-sql-developer-gui.html

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 :
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

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.