{{parent page="Oracle"}}

===Oracle SQLs===
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
%%