SQL*Plus Quick Start

This chapter contains single pages of instructions to get you up and running after you have installed SQL*Plus.

• iSQL*Plus Quick Start
• SQL*Plus Command-line Quick Start for Windows
• SQL*Plus Command-line Quick Start for UNIX

Some Resources

Here are some resources you might find useful when working with iSQL*Plus:

• SQL*Plus Discussion Forum
• SQL*Plus on the Oracle Technology Network
• SQL*Plus Product and Documentation feedback

iSQL*Plus Quick Start

Do the following steps to start iSQL*Plus:

1. Connect to the Internet or your intranet, and start your web browser.
2. Enter your Oracle9i HTTP Server URL, followed by isqlplus, in your web browser's Location or Address field. The iSQL*Plus URL looks like this:

   http://machine_name.domain:port/isqlplus
   

   If you do not know the Oracle9i HTTP Server URL, ask your System Administrator.

3. Press Enter to go to the URL. The iSQL*Plus Login screen is displayed in your web browser.
4. Enter your Oracle9i username and password in the Username and Password fields. If you do not know your Oracle9i username and password, ask your Database Administrator.
5. Leave the Connection Identifier field blank to connect to the default database. Enter the Oracle Net database alias to connect to a database other than the default. If restricted database access has been configured, the Connection Identifier field will be a dropdown list of available databases you can select.
6. Click Login to connect to the database. The iSQL*Plus Work screen is displayed in your web browser.

   Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands in the Work screen Input area.

SQL*Plus Command-line Quick Start for Windows

Do the following steps to start SQL*Plus and connect to the default database:

1. Open a Windows command prompt.
2. At the command-line prompt, enter the SQL*Plus command in the form:

   c:\> sqlplus
   

3. When prompted, enter your Oracle9i username and password. If you do not know your Oracle9i username and password, ask your Database Administrator.
4. SQL*Plus starts and connects to the default database.

   Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt.

Do the following to start SQL*Plus and connect to a specified database other than the default:

1. Start SQL*Plus and connect to the default database.
2. Use the CONNECT command to specify the Oracle Net database alias (@connect_identifier) of the database you want to connect to. To do this enter the CONNECT command in the form:

   SQL> connect username/password@connect_identifier
   
   

   To hide your password, enter the CONNECT command in the form:

   SQL> connect username@connect_identifier
   
   

   You will be prompted to enter your password.

3. Alternatively, to start SQL*Plus connected to a database other than the default, enter the SQL*Plus command in the form:

   c:\> sqlplus username/password@connect_identifier
   
   

   To hide your password, enter the SQL*Plus command in the form:

   c:\> sqlplus username@connect_identifier
   
   

   You will be prompted to enter your password.

SQL*Plus Command-line Quick Start for UNIX

Do the following steps to start SQL*Plus and connect to the default database:

1. Open a UNIX terminal.
2. At the command-line prompt, enter the SQL*Plus command in the form:

   $> sqlplus
   

3. When prompted, enter your Oracle9i username and password. If you do not know your Oracle9i username and password, ask your Database Administrator.
4. SQL*Plus starts and connects to the default database.

   Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt.

Do the following to start SQL*Plus and connect to a specified database other than the default:

1. Start SQL*Plus and connect to the default database.
2. Use the CONNECT command to specify the Oracle Net database alias (@connect_identifier) of the database you want to connect to. To do this enter the CONNECT command in the form:

   SQL> connect username/password@connect_identifier
   
   

   To hide your password, enter the CONNECT command in the form:

   SQL> connect username@connect_identifier
   
   

   You will be prompted to enter your password.

3. Alternatively, to start SQL*Plus connected to a database other than the default, enter the SQL*Plus command in the form:

   $> sqlplus username/password@connect_identifier
   
   

   To hide your password, enter the SQL*Plus command in the form:

   $> sqlplus username@connect_identifier
   
   

   You will be prompted to enter your password.