Translate

Thursday 6 March 2014

Connection with Oracle SQL Developer

sql Developer connection New connection

step 1

Open SQL Developer

step 2

click New Connection

step 3

step 4

connection name anything you can give

give username and password

Then follow Next step

step 5

Go the installed drive where your ORACLE insalled

in my system

C:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN

And the file

tnsnames

open with notepad

step 6

step 7

test

step 8

success

step 9

Enter SQL statement

step 10

Enter SQL statement

Execute The Statement (F9)

step 11

see your table

Wednesday 5 March 2014

sql Developer mode used

sql Developer Demobld.sql

How to use sql Developer

step 1

If you are not download yet Steps for

step 2

After downloading install it

step 3

step 4

step 5

click finish

step 6

step 7

step 8

C:\Program Files\Java\jdk1.7.0\bin

Select the .exe file OK

step 9

MY COMPUTER PROPERTIES

put SEMICOLON then past the link

;C:\Program Files\Java\jdk1.7.0\bin

step 10

NOW Open the SQL Developer

Saturday 1 March 2014

demobld.sql

Demobld.sql Download Demobld.sql

demobld.sql