Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: shell execution based on sql select results...

Re: shell execution based on sql select results...

From: MDavis9 <mdavis9_at_aol.com>
Date: 31 Aug 1998 03:01:27 GMT
Message-ID: <1998083103012700.XAA06330@ladder01.news.aol.com>

You can store the output of the Sql statement to a variable, then use this variable for your evaluation.
Ex. var=$(sqlplus -s Select.....)
if var
then

exit
fi
Good Luck
Mike Received on Sun Aug 30 1998 - 22:01:27 CDT

This message: [ Message body ]
Next message: choi, sang soon: "Oracle error Help!!!!!"
Previous message: Shirley Burk: "Re: SQL and Oracle Tuning"
In reply to: TheKarma_at_yahoo.com: "shell execution based on sql select results..."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US