Step 1 : If you are on a Windows system, display a Windows command prompt. Connect to Oracle database using SQL PLUS :
To exit SQL Developer, select Exit from the File menu. You are in the SQL Developer environment. The Connections frame shows the connection whose name you entered in the Connection Name field in step 3. §The New/Select Database Connection window closes. §If the test succeeded, click the button Connect. If the connection succeeds, the Status indicator changes from blank to Success. §(The default values are: Connection Type, Basic Role, default, Hostname, localhost Port, 1521 SID option, selected SID field, xe.) §In the Oracle pane, accept the default values. §If the Oracle pane is not showing, click the tab Oracle. §Near the Password field is the check box Save Password. §For security, the password characters that you type appear as asterisks. §Type the appropriate values in the fields Connection Name, Username, and Password. In the New/Select Database Connection window: Step 3 : Go to connections frame and click to add new connection
#Oracle sql developer tool full#
Either type the full path after the prompt or browse to it, and then press the key Enter. 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). Step 2 : Important instruction if you are opening Oracle SQL developer first time. Steps to connect to oracle database :įor more instructions you can check : Oracle Database SQL Developer User’s Guide.
#Oracle sql developer tool how to#
In this article i would like to throw light on How to connect to oracle database using sql developer with real example. 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 my previous article i have already given the difference between the Oracle anonymous block and subprogram with real life examples.
0 kommentar(er)
