Hi.
I started using a SQL decode to replace null occurences with 'n/a' but ended up using Cero sugestion.
Didn't remember about using set null.
This workaround will have to do.
I need to output a 4 queries result into another application using
result=`sqlplus -s ${3}/${4}@${2} << EOF
...
query1
query2
query3
query4
....
echo "$metrics1"