KfWiki: Oracle SQLs

HomePage » Database » Oracle » OracleSQLPlus

Prevent sqlplus from parsing "&" as input prompt

SET DEFINE OFF

Edit history in sqlplus

ed

Turn off heading and start sqlplus in silent mode - useful for batch job

sqlplus -S / <<EOF
set heading off
set feedback off
<your queries>
EOF

Set editor

define_editor vi

KfWiki : OracleSQLPlus