Explain how to fetch two values from database into two variables in shell scripting?
Submitted by: AdministratorIn 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Scripting Job Interview Questions And Answers
Top Scripting Questions
☺ | How to disable back button in Mozilla? |
☺ | Explain how to execute WScript & WSH object? How will i create WSH objects? |
☺ | Explain how to fetch two values from database into two variables in shell scripting? |
☺ | How to disconnect the vpn client in VB Script? |
Top Scripting language Categories
☺ | AngularJS Interview Questions. |
☺ | Ext-JS Interview Questions. |
☺ | Dojo Interview Questions. |
☺ | Expert Developer JavaScript Interview Questions. |
☺ | jQuery Mobile Interview Questions. |