쉘스크립트 안에서 SQL 실행하기

TZ=KST+15 date +%Y%m%d  

sqlplus /nolog << __END__
conn sigadk/sigadk@trend
update sigadk_contents set regdate='`TZ=KST+15 date +%Y%m%d`' where regdate is null;

commit;

exit
__END__