Re: How to pass a values from sqlplus to Unix prompt.
[email protected] Mon, 3 Mar 2003 12:01:50 +0000
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-895526-2003.03.03-12.02.42--gcdod-oracle#[email protected]> |
This will get you going
Make a file called test.sql with the following contents.
set head off
set pages 0
set feed off
select sysdate from dual
/
exit
Then in your unix script call
MYVAR=`sqlplus -S scott/tiger @test.sql`
echo $MYVAR
Good Luck
Chris Farmer
"Rajiv Khatri"
<rajiv.khatri@pat To: "Oracle" <[email protected]>
ni.com> cc:
Subject: [oracle] How to pass a values from sqlplus to Unix prompt.
03/03/2003 04:20
Please respond to
"Oracle"
Hi All,
How to pass a values from sqlplus to Unix prompt.
Thanks & Regards
Rajiv
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to %%email.unsub%%.
---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to [email protected].