$sqlplus username/password@servie_name

SQL> SELECT SYSDATE FROM DUAL;

SQL> SELECT D.DNAME,E.ENAME,E.JOB,E.HIREDATE 
	FROM EMP E,DEPT D 
	WHERE TO_CHAR(E.HIREDATE,'YYYY')='1981' AND E.DEPTNO=D.DEPTNO;

------------------------------------------------------------------------    	
	su - oracle -c "sqlplus scott/tiger@servie_name"<<EOF
	spool /oracle_backup/log/scott_select.txt;
	@/oracle_backup/bin/scott_select.sql;
	spool off;
	exit;
 -------------------------------------------------------------------------

$chmod 755 /oracle_backup/bin/scott_select.sh

Sun Solaris	文件	/var/spool/cron/crontabs/root
    Linux	文件	/var/spool/cron/root

40 4 18 * * /oracle_backup/bin/scott_select.sh

Sun Solaris
    #/etc/rc2.d/S75cron stop
    #/etc/rc2.d/S75cron start
    Linux
    #/etc/rc.d/init.d/crond restart