How to run a SQL select query in Oracle database through a shell script?

Question

I need to run a SQL select query in an Oracle database and have to capture the list of retrieved records in a shell script. Also I would like to modify the query for certain conditions and need to fetch it again. How can I do this?

Is there a way to have a persistent connection to an Oracle database using a shell script?

Answer 1

You can do something like the following:

#!/bin/bash

DatabaseconnectStr=user/password@ALIAS
Dynamic=DynamicContent

sqlplus -S ${DatabaseconnectStr} << EOF

spool results.out
SELECT * FROM YOUR_TABLE WHERE COLUMN = ${Dynamic} ;
spool off
exit;
EOF