To exit SQL Developer, select Exit from the File menu.Įxample 2-2 Viewing HR Schema Objects with SQL*Plus 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.ĭescription of the illustration success.gif
(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. Type the appropriate values in the fields Connection Name, Username, and Password.įor security, the password characters that you type appear as asterisks. In the New/Select Database Connection window: In the Connections frame, click the icon New Connection. Either type the full path after the prompt or browse to it, and then press the key Enter. exe (for example, C:\Program Files\Java\jdk1.6.0_021\bin\java.exe). If this is the first time you have started SQL Developer on your system, you are prompted to enter the full path to java. To connect to Oracle Database from SQL Developer:įor instructions, see Oracle Database SQL Developer User's Guide. exe in step 1.įor step 3, you need a user name and password. If you're using a SQL Developer kit that does not include the JDK, then the first time you start SQL Developer on your system, you must provide the full path to java.
0 kommentar(er)
