nutsh
8/30/2013 - 8:44 AM

execute Sql via sql plus in Shell

execute Sql via sql plus in Shell

sqlplus -s sys/oracle AS sysdba << EOF
whenever sqlerror exit sql.sqlcode;

select 1 from dual;      --dbscript
@sample.sql              --filename

exit;
EOF