Assigning multiple column's value from oracle query to multiple variables in Unix
<p>I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).</p>

<p>I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I could use 'cut' and assign values to all the required 10 variables from V.</p>

<p>But the thing is some of the the columns have special character and it is kind of hard for me to cut out the required details. Sometimes the delimiter(;)itself is present in column value. Also the code is very lengthy. </p>

<p>Is there a better way to assign multiple column values from query to unix variables.?</p>

<p>Also when i read '-e' from query and pass it unix varaible it becomes '?e'. Is there anyway we could solve this.</p>

<p>Thanks.</p>