- Double link Hyperlink in HTMLHow to create "Double Line Hyperlink" in HTML?
- Javascript for Website validationHow to validate website address using javascript? User should not be allowed to enter special characters except hyphen(-).
- Connect to Database and Execute a ScriptHow do we connect to Oracle database, execute a script and assign its output to a shell variable?
How do we do a bulk load to an oracle table using shell script - Disable back button in MozillaHow to disable back button in Mozilla?
- 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? You must first Login or Register to view all 10 questions from this category.
Registering yourself is FREE, takes just less than a minute and opens up a whole new GetGyan experience.