Skip to content

Tag: sqlplus

sqlplus query + loop on linux

I have pratically 0 experience on unix and few on mysql and I am finding hard where to start to complete this task, I have to write a .sh file to launch once a day. I have a table on OracleDb where I have 2 columns I need: path and file_name. Once I get the results, I should loop through

How to connect to SQLPLUS and run SQL script within ssh unix?

I have the following bash script: Now, I want to run te following sql script (which is on the other device I’m accessing): How is the best practice to run the script from that path? I’ve seen a suggestion to add “/usr/mikael/myfile.sql” to the end of the command, as : Is that really good? (I’m working on a prod environment