usefull commands

por | 6 abril, 2015

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