All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
253 views

How to capture only the stderror in this bash script?

this is my scash script query="select * from blabla;" sqlplus64 -S /nolog <<ENDOFSQL>>errorLog.txt CONNECT username/pwd@domainName:1521/serviceName ...
0
votes
1answer
124 views

how to concatenate Login, pwd and @server variables?

how to concatenate Login, pwd and @server variables ?? ex: export Login_va="Login" export pwd_va="pwd" export server_var="@server" echo whenever sqlerror exit | sqlplus $Login/$...
-1
votes
1answer
2k views

save output into a file from sqlplus query in ksh script

The thing is that it overwrites in Result.txt and I only get the last query. How can I fix this? #!/bin/sh while read -r line do echo "'$line'" sqlplus -s whatever/whatever <<-EOF SPOOL ...
1
vote
2answers
13k views

Pass shell variables to SQL statement

I want to pass shell variables to an SQL statement. Both shell script and SQL statement are present in the same script file. I want the values of the variables retMonth, retLastDay and retPrvYear in ...