Create and Manage Oracle Database Using Oracle SQL Developer GUI

Pre Requisites:

1. Oracle SQL Developer
2. Oracle Database Instance Login Details

Complete Video Tutorial

Step 1:

Install Oracle SQL Developer

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

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.

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

 

Step 2:

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

Select Schema

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

Similarly create second table : department

 

Now Create Foreign Key as shown to link Department Id from Employee table to Department Table

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

Now open the SQL qorkspace and Paste the code and Click Run as shown. This will create the table.

 Continue to Part 2 of this tutorial to integrate this to Visual Studio net MVC .