Hi guys,
I have a problem. Actually I must receive the value of a variable(UNIX) from a table. How can I do it? More simply:
I have the table which has the value 200403 in default DB of the system. How can I pass this value to a local variable in unix script?

Thanks in advance,
ducasio

Code:

VAR=`$ORACLE_HOME/bin/sqlplus -s un/pwd@db <<EOF
whenever sqlerror exit 1
set escape off
set head off
set verify off
select to_char(SYSDATE,'YYYY-MM-DD') from dual;
EOF
`

great, it works,
thanks a lot.

ducasio