How to fetch two values from database into two variables in shell scripting.

In order to get 1 value from DB and assign it to variable in shell script i use following syntax:

sqlplus /nolog << EOF | read xyz

SET LINESIZE 100
SET PAGESIZE 50
SELECT emp_sal
FROM emp
where emp_id=789;
EOF

hence, xyz variable gets emplyoee salary.

No my question is, I want to fetch emp_sal and emp_adrs and store it in two variables (xyz and abc).

How do I do that?

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions