[oracle@jumper oracle]$ cat a.sh
sqlplus -S "/ as sysdba" << !
set heading off
col today noprint
column today new_val dat
select to_char( sysdate, 'yyyy-mm-dd') today from dual;
host echo 'today is ' &dat
exit;
exit;
!
[oracle@jumper oracle]$ ./a.sh
today is 2005-04-11
[oracle@jumper oracle]$
SQLPLUS 向SHELL传递变量
最新推荐文章于 2022-11-24 08:30:00 发布