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

sql

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.

amazon

  • Hostname :
  • Username :
  • Password :
  • Service Name :
  • Port No :

Step 3 :

Extract the Downloaded SQL Developer tools to a folder and open the file SQL Developer

sqldev

 

sql2

 

 

This will Open Developer

screen1

Now Import Data Dictionary as shown

opendatadictionary

Enter the Oracle DB Details

createconnection

Select Schema

selectschema

Dont select any DB Tables as we are going to create new Tables

nodb

finishwizard

 

 

Now click Insert Table. Drag workspace to new table , enter table Name it as Employee and Click OK

tab1

Now Create Columns as Shown

tab2

Similarly create second table : departmenttab3

 

tab4

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

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 .

tab7 tab8

Now copy the generated DDL

tab9

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

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