SQLPlus - Useful Command

Useful command in sqlplus.

The slash command (/) rerun the last query : /

gerardnico@orcl>select 'test' FROM dual;
 
TES
----
test
 
gerardnico@orcl>/
 
TES
----
test

The exclamation mark an the begin of a command permit to send an shell command.

SQL> !pwd
/home/oracle

The question mark is the equivalent of the ORACLE_HOME directory

Example: to start the compilation script utlrp.sql

@?/rdbms/admin/utlrp.sql

@ is an equivalent of the START command.

This script recompiles all PL/SQL modules that might be in an invalid state, including packages, procedures, and types.