In earlier post ,we have seen how to install SQL developer and now lets check out how can we add connection/schema to SQL developer.
Open SQL developer and click on new connection as shown below.
now pop up window ill open to ask you for details as below.
here mainly you have to concentrate on
1) username and password ==> These can be get it from DBA .
2) SID==> it means you need to mention your database name
3) Host name ==> Let it be local host if database is installed in your machine otherwise you have provide IP address of where database is installed.
Now you can do testing of your connection by clicking on "Test" and you can see status .
If its success then you can click on connect and use it for your work.
Open SQL developer and click on new connection as shown below.
now pop up window ill open to ask you for details as below.
here mainly you have to concentrate on
1) username and password ==> These can be get it from DBA .
2) SID==> it means you need to mention your database name
3) Host name ==> Let it be local host if database is installed in your machine otherwise you have provide IP address of where database is installed.
Now you can do testing of your connection by clicking on "Test" and you can see status .
If its success then you can click on connect and use it for your work.
No comments:
Post a Comment