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

No comments:

Post a Comment