Lesson -2 - SQL*Plus

Lesson -2   - SQL*Plus

 

This  section will provide a basic understanding of SQL*Plus.

SQL*Plus is Oracle tool which helps to create and manipulate database objects.

SQL*Plus enables you to manipulate SQL commands and PL/SQL blocks.

Using SQL*Plus, you can:

• Enter, Edit, Store, Retrieve, and execute SQL commands and PL/SQL blocks
• Formatting, perform calculations on, store, and print query results in the form of reports
• list column definitions for any table
• access and copy data between SQL databases

Starting SQL*Plus

This example shows you how to start SQL*Plus. Follow the steps shown.

1. First login to your system
2. Enter the command ``sqlplus orcle-user-name/password@connect-string'' at command prompt
   Note: This example assumes that you have been given the same ORACLE user ID as your login.

Example :

C:/sqlplus scott/tiger@devdb

Here, scott is oracle username or schema, tiger is password of scott and devdb is connect string ( connect string holds information about database server & instance and an entry from tnsnames.ora file which we will see it later)

3.  SQL*Plus displays its version number, the date, and copyright information, and automatically checks your authentication. Next, SQL*Plus displays the SQL*Plus command prompt:

          SQL>

The command prompt indicates that SQL*Plus is ready to accept your commands.

Leaving SQL*Plus

To leave SQL*Plus, enter the ``EXIT'' or ``QUIT'' commands at the SQL*Plus command prompt

              SQL> QUIT