Home » SQL & PL/SQL » SQL & PL/SQL » Unix + Oracle connection
Unix + Oracle connection [message #206985] Sun, 03 December 2006 00:44 Go to next message
Messages: 68
Registered: March 2006

Using a shell script I have to check the 4 values from a table in Oracle and then store the result as "Y" in a Unix variable if the values are desired and "N" if the values are not desired.


There is a table abc in oracle which has 4 fields. if all the four values comes out to be 1 then i want to assign a Unix variable "result" as "Y".

If even one of the values is "0" then i want to assign the UNIX variable "result" as "N".

All this has to be done using UNIX shell scripting.

Request the experts to come ahead and help me.

Re: Unix + Oracle connection [message #207161 is a reply to message #206985] Mon, 04 December 2006 06:20 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Show us what you've tried, and what problems you're having.
Previous Topic: Help Needed for ideal approach!
Next Topic: oracle procedure out parameter and visual basic
Goto Forum:

Current Time: Wed Jul 26 12:21:58 CDT 2017

Total time taken to generate the page: 0.10047 seconds