dba:oracle:docs:sqlplus_basics
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
dba:oracle:docs:sqlplus_basics [2023/01/31 08:23] – removed - external edit (Unknown date) 127.0.0.1 | dba:oracle:docs:sqlplus_basics [2023/01/31 08:28] (current) – ↷ Links adapted because of a move operation dodger | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== [DOC] SQLPLUS basics ====== | ||
+ | |||
+ | =====Notas===== | ||
+ | * Comillas dobles es literal case sensitive, comillas simples no (todo a UPPER), al revés que linux. | ||
+ | |||
+ | =====Editor===== | ||
+ | ====Definir==== | ||
+ | <code sql> | ||
+ | ====Editar==== | ||
+ | <code sql> | ||
+ | ====Re-ejecutar==== | ||
+ | <code sql> | ||
+ | |||
+ | =====Escape de caracteres especiales===== | ||
+ | Los 4 caracteres a escapar son: | ||
+ | ^ Caracter ^ Secuencia de escape ^ Ejemplo ^ | ||
+ | | <code sql>'</ | ||
+ | | '' | ||
+ | SET ESCAPE ' | ||
+ | |||
+ | [[http:// | ||
+ | =====Separador de columnas===== | ||
+ | <code sql> | ||
+ | SET COLSEP < | ||
+ | </ | ||
+ | =====Tamaño de linea===== | ||
+ | <code sql> | ||
+ | SET LINESIZE < | ||
+ | </ | ||
+ | =====Tamaño de página===== | ||
+ | <code sql> | ||
+ | SET PAGESIZE < | ||
+ | </ | ||
+ | =====Limitar el numero de resultados de una query===== | ||
+ | <code sql> | ||
+ | SELECT | ||
+ | WHERE rownum <= 10 ; | ||
+ | </ | ||
+ | =====Configurar el backspace===== | ||
+ | En el caso de que el backspace genere " | ||
+ | <code sql> | ||
+ | En cada caso cambiará el símbolo usado. | ||
+ | |||
+ | |||
+ | =====Ir a shell desde sqlplus===== | ||
+ | <code sql> | ||
+ | ! | ||
+ | </ | ||
+ | con esto se ejecuta un bash y luego vuelve a SQL+. | ||
+ | |||
+ | |||
+ | ===== wrapper ===== | ||
+ | * [[..: | ||