UNIX for Advanced & Expert Users

$ORACLE_HOME/bin/sqlplus -S "$db"<<! | tee -a >$INFA_HOME/server/infa_shared/CTRL.log

select * from TAB WHERE LOAD_TYPE='D';




from database

 select * from TAB WHERE LOAD_TYPE='D';
XX	11/30/2009	12/1/2009	



CTRL.log


Source                                            PREVIOUS_ CURRENT_B 
-------------------------------------------------- --------- --------- 
XX                                               30-NOV-09   01-DEC-09

select to_char(SYSDATE, 'DD-MON-YYYY') from dual;
select to_char(SYSDATE, 'DD-MM-YYYY') from dual;
select to_char(SYSDATE, 'DD/MM/YYYY') from dual;