In the following csh script,
I'd rather set a variable
than output to a file that I have to delete:

====================================
#! /bin/csh

sqlplus -s my_logon  > my_result <<!

set heading off feedback off verify off

select to_char(sysdate, 'YYYYMMDD_SSSSS') from dual;

!

echo "time stamp is: " `cat my_result`

'rm' -f my_result
====================================

So, how do I set a csh variable to the result of the "select"?

Any help would be appreciated
(except for comments concerning style and "do it in ksh").  ;)

Thanks!

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to