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



      I told my wife she was drawing her eyebrows too high.    
      She looked surprised.