Slide 3.16: Using SQL*Plus, the Oracle interface (cont.)

Using SQL*Plus, the Oracle Interface

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. Our SQL*Plus is located

   /usr/lib/oracle/23/client64/bin/sqlplus

and you do NOT need to set up the environment in order to use it.

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