Any idea why a sqlplus command executed in a linux script with sqlplus -s will produce the output twice? When I run it from a sqlplus prompt, I get it only once.
Query: select job from job_table where machine='value'.
From a sqlplus prompt I get 40 rows.
From the linux shell script I still get 40 rows, but I get them twice.
script is:
sqlplus -s ${cs} <<-EOF
set head off
select job
from job_table
where machine='$1'
order by job;
/
EOF
Query: select job from job_table where machine='value'.
From a sqlplus prompt I get 40 rows.
From the linux shell script I still get 40 rows, but I get them twice.
script is:
sqlplus -s ${cs} <<-EOF
set head off
select job
from job_table
where machine='$1'
order by job;
/
EOF
via International Skeptics Forum http://bit.ly/2JlLamx
Aucun commentaire:
Enregistrer un commentaire