What I want to do is return the value from my query back to the calling UNIX ksh program.

I run the command from my ksh script
> runsql.ksh

echo "Script starting"

sqlplus ${OP_CONNECT_STRING}@${OP_ORA_INST} @sqls/sel_logical_dt.sql

echo $date

echo "Script ending"

>

In my sel_logical_dt.sql file I have

select date from logical_date;

I want to return this date back to the calling unix progam for display.