Slide 5.7: Using SQL*Plus, the Oracle interface

Using SQL*Plus, the Oracle Interface

Do not forget to execute the following command before using SQL*Plus:

     undcemcs02> source ~/.profile

which specifies our JDBC uses

   /usr/lib/oracle/12.1/

and the SQL*Plus uses

   /usr/lib/oracle/12.2/

SQL*Plus, the Oracle command-line interface, enables users to manipulate SQL commands and PL/SQL blocks. Programmers and DBAs commonly used it as the default available fundamental interface in almost any Oracle software installation.

help [ topic ] | help

HELP displays information on the commands of SQL*Plus, SQL, and PL/SQL. For example, the following command displays help on SELECT, SET commands, and SET operator.

    SQL> help se

help index

Lists SQL*Plus, PL/SQL, and SQL commands.

    SQL> help index

list [ *|n [m|last] ] or n

LIST displays one or more lines of the SQL buffer.

   SQL> list 
     1  SELECT * FROM customers 
     2*   WHERE name = 'Pokemon';

change /old/new

Uses CHANGE to replace the first occurrence of the specified text on the current line of the buffer with the new specified text.

   SQL> 1 
     1* SELECT * FROM customers
   SQL> c /customers/agents 
     1* SELECT * FROM agents