Top "Sqlplus" questions

Suppress output of variables substitution in sqlplus

I'd like to suppress the output of such lines as the following ones old 9: AND FROMDAT <= TO_DATE('&…

sql variables sqlplus

Append to spool file Oracle

I have one script file called Test.sql in D:\Scripts folder and the content of the file is given …

sql oracle append sqlplus spool

What is the Difference between SQL and SQL*Plus?

What is the Difference between SQL and SQL*Plus?

sql sqlplus

Column headings keep appearing throughout Oracle output

After ever 10 lines, my column headers reappear in my Oracle output. Is there something about my code or some kind …

oracle sqlplus

How do I capture a SQLPlus exit code within a shell script?

I have a KornShell (ksh) script that logins into SQL*Plus and executing a script. Within the shell script I …

shell error-handling scripting sqlplus ksh

sqlplus remote connection giving ORA-21561

I have installed sqlplus based on instruction given here sqlplus 'username/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.100)(PORT=1521))(CONNECT_DATA=(…

oracle sqlplus

ORA-12162: TNS:net service name is incorrectly specified on Mac OS X Lion

I am trying to connect to an oracle database using oracle sqlplus instant client using tnsnames.ora. But getting this …

osx-lion sqlplus tnsnames

Dumping CLOB fields into files?

Say you have the table: Column_name | data_type Title | Varchar2 Text | CLOB with some rows: SomeUnkownMovie | A long time …

oracle sqlplus dump clob

Sql*plus always returns exit code 0?

Whenever I run a sql script using Sql*plus and check for $?, I get 0 even when the script wasn't succesful. …

oracle scripting sqlplus exit-code

Oracle error when executing sqlplus: "SP2-1503: Unable to initialize Oracle call interface"

I'm struggling with the following error when starting up sqlplus as my regular user - say "scott". $ sqlplus SP2-1503: …

linux oracle11g sqlplus opensuse