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
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
SQL> help index
LIST
displays one or more lines of the SQL buffer.
SQL> list 1 SELECT * FROM customers 2* WHERE name = 'Pokemon';
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. |