list
SQL> define
DEFINE _DATE = "06/04/15" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcl" (CHAR)
DEFINE _USER = "SYSTEM" (CHAR)
DEFINE _PRIVILEGE = "" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1201000100" (CHAR)
DEFINE _EDITOR = "Notepad" (CHAR)
DEFINE _O_VERSION = "Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE = "1201000100" (CHAR)
>define _EDITOR = «notepad»
>edit
runs the query
>/
Column format and Pagination
column topic format a12;
set pagesize 0;
SELECT TOPIC, SEQ FROM HELP;
para salida de un archivo de texto
spool employee.txt
al terminar
spool off