How to Get SQLPLUS Query Output to a Shell Script Variable
Most of the time during the shell
scripting we get requirement to get the database table query result values to a
shell script variables. Here is one example to get a single column values to a
variable. If you have multiple column outputs then we will have to concatenate
into a single column and pass it to the shell script variable. You can use awk
or scripting commands to make it separate.