Shell Programming and Scripting

Hi All,

I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below

Code:

 
sqlplus user/pwd@dbname << EOF > output.log
$(<inputfile.txt)
EOF

The above code is capturing the output of queries into output.log but the thing is, the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input??

Thanks in Advance.

I am not sure about the oralce. But set echo on will display the input query also.. ( i guess not sure... )

---------- Post updated at 01:55 PM ---------- Previous update was at 01:50 PM ----------

ORACLE-BASE - Oracle Shell Scripting

Thanks for your immediate reply. I already tried settting echo ON. But this didn't help. The output still has only the output of the query without displaying the query.

When I need to do what you're trying to do, i use this set of sets. Don't know which one is the right one, probably set serveroutput on.

Code:

 
set time on
set timing on
set echo on
set linesize 132
set head off
set scan on
set serveroutput on

Hi Arkadia,

'set serveroutput on' helps in displaying the output. The probelm i'm facing is to display the input query which i'm passing from the text file and not with the output associated with it.

You can use the list command to see the last query executed (after it is executed).

Code:

$ sqlplus -s /nolog << !
connect scott/tiger@DB1
set heading off
select 135 from dual;
list
!
 
135
 
1* select 135 from dual

Scott,
Thanks for the reply. Came to know about list command for the first time.
But i have a number of queries in the input file and i want to display the input query with corresponding output for each of the query. Is there any other way i can achieve this functionality.

Thanks in Advance.