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?