How To Integrate SQLPLUS Command Within Shell Scripts

If you want to keep one scripts that consists of SQLPlus connection following is the method to do it.



sqlplus -s '/as sysdba' << endofcommand

SELECT SYSDATE FROM DUAL;

SELECT banner FROM v\$version;

SELECT COUNT(*) FROM v\$session WHERE username like 'SYS%';

EXIT
endofcommand