I execute the following query which returns one value and it works fine. The issue is that when the one value returned is too large it gets split in multiple rows thus the ETL tool that I further use gets problems. Therefore I have tried to use the linesize option but I am not able to combine it with the
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 go…
cannot call sqlplus from linux where password contains $ dollar sign
I have spent hours trying various suggestions and combinations but for the life of me cannot get a call to sqlplus from direct linux command line or from a bash script to work with a password containing a $ I have tried these I have tried the same as above but putting before the $, and various other attempts
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 11.2.0.3.0 Production on Tue Oct 18 07:12:49 2016 Copyright (c) 1982,…
Connect to sqlplus with another linux user than oracle
I installed Oracle with sqlplus with user oracle (linux – CentOS). If I try to connect to database being oracle everything goes as expected (sqlplus / as sysdba for example), but I need to do the same thing (maybe not as sysdba, but as a user from database) being another linux user. I added this second …