In my previous article i have already given the difference between the Oracle anonymous block and subprogram with real life examples. In this article I would like to give you steps to connect to oracle database using SQL server with example.The Oracle SQL developer is the tool which will easily connect to Oracle with using tnsnames.ora or other systems. In this article i would like to throw light on How to connect to oracle database using sql developer with real example.
Steps to connect to oracle database :
Step 1 :
Start oracle SQL developer
For more instructions you can check : Oracle Database SQL Developer User’s Guide.
Step 2 : Important instruction if you are opening Oracle SQL developer first time.
If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java.exe (for example, C:\Program Files\Java\jdk1.6.0_021\bin\java.exe). Either type the full path after the prompt or browse to it, and then press the key Enter.
Step 3 : Go to connections frame and click to add new connection
In the New/Select Database Connection window:
§Type the appropriate values in the fields Connection Name, Username, and Password.
§For security, the password characters that you type appear as asterisks. §Near the Password field is the check box Save Password. By default, it is deselected. Oracle recommends accepting the default.
§If the Oracle pane is not showing, click the tab Oracle. §In the Oracle pane, accept the default values.
§(The default values are: Connection Type, Basic; Role, default, Hostname, localhost; Port, 1521; SID option, selected; SID field, xe.)
§Click the button Test.
§The connection is tested. If the connection succeeds, the Status indicator changes from blank to Success.
§If the test succeeded, click the button Connect.
§The New/Select Database Connection window closes. The Connections frame shows the connection whose name you entered in the Connection Name field in step 3.
You are in the SQL Developer environment.
To exit SQL Developer, select Exit from the File menu.
Connect to Oracle database using SQL PLUS :
Step 1 : If you are on a Windows system, display a Windows command prompt.
Step 2 : At the command prompt, type sqlplus and then press the key Enter.
Step 3 : At the user name prompt, type your user name and then press the key Enter.
Step 4: At the password prompt, type your password and then press the key Enter.
These are steps to connect to oracle database using SQL developer. I hope you like this article. If you like this article or if you have any issues with the same kindly comment in comments section.