Oracle Database from SQL*Plus

To connect to Oracle Database from SQL*Plus:

If you are on a Windows system, display a Windows command prompt.

At the command prompt, type sqlplus and press the key Enter.

SQL*Plus starts and prompts you for your user name.

Type your user name and press the key Enter.

SQL*Plus prompts you for your password.

Type your password and press the key Enter.

Note:

For security, your password is not visible on your screen.

The system connects you to an Oracle Database instance.

You are in the SQL*Plus environment. At the SQL> prompt, you can enter and run SQL*Plus commands, SQL statements, PL/SQL statements, and operating system commands.

To exit SQL*Plus, type exit and press the key Enter.

Note:

Exiting SQL*Plus ends the SQL*Plus session, but does not shut down the Oracle Database instance.

Example 2-1 starts SQL*Plus, connects to Oracle Database, runs a SQL SELECT statement, and exits SQL*Plus. User input is bold.

Example 2-1 Connecting to Oracle Database from SQL*Plus

> sqlplus

SQL*Plus: Release 11.2.0.0.1 - Beta on Mon Jun 9 15:31:26 2008

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter user-name: your_user_name

Enter password: your_password

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.0.0 - Development

With the Partitioning, Data Mining and Real Application Testing options

SQL> select count(*) from employees;

COUNT(*)

----------

107

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.0.0 - Development

With the Partitioning, Data Mining and Real Application Testing options

>

See Also:

"Connecting to Oracle Database as User HR from SQL*Plus"

"About SQL*Plus" for a brief description of SQL*Plus

SQL*Plus User's Guide and Reference for more information about starting SQL*Plus and connecting to Oracle Database

Connecting to Oracle Database from SQL Developer

SQL Developer is a client program with which you can access Oracle Database. This section assumes that SQL Developer is installed on your system, and shows how to start it and connect to Oracle Database. If SQL Developer is not installed on your system, see Oracle Database SQL Developer User's Guide for installation instructions.

Note:

For the following procedure:

The first time you start SQL Developer on your system, you must provide the full path to java.exe in step 4.

For step 7, you

...