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

Accessing Oracle Wallet using Oracle sqlplus Instant client

I’ve configured Oracle wallet successfully in my Linux server(Linux 2.6.32-642.4.2.el6.x86_64 GNU/Linux). When I try to execute the below command using Database connection string, it works perfect. $/sqlplus /@TESTDB SQL*Plus: Release Production on Tue Oct 18 07:12:49 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release – 64bit Production With the