libclntsh.so.11.1: cannot open shared object file.?

I want to schedule a task on Linux by icrontab, and the task is written in python and have to import cx_Oracle modul...

how to give comments in sql?

i am working in SQL one question is raised about the SQL comments,please give me complete explanation. gi...

SQL - Missing right parenthesis?

I am trying to execute this script in Oracle 11g and getting the following error, I dont know where I am missing the...

Oracle rownum behavior with mod function?

Given CREATE TABLE Foo(v1 integer, v2 integer); INSERT INTO Foo VALUES (1,2); INSERT INTO Foo VALUES (3,4); INSERT...

copy from one database to another using oracle sql developer - connection failed?

I am trying to copy a table from one database to another using oracle sql developer. I have the username, password a...

ORA-01741: illegal zero-length identifier?

Hi I am using a delete query in my shell script and I am facing this issue. delete from WHITELIST_CLI where file...

ORA-01797: this operator must be followed by ANY or ALL error?

While I am executing the query, select * from file_log f where F.DCP_SRCE_FILENM_FK in ('ABC','DEF') and F.TR...

Sqlplus login error when using bash variables: SP2-0306: Invalid option?

I have a bash script that connects to an oracle 10g database. In a first step it takes some variables from a "confi...

BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed?

I am getting this error while on of my .Net application are trying to make a connection to oracle database. The err...

oracle.net.ns.NetException: Socket read timed out?

I have this error after executing my batch : 2015-11-06 15:45:32,179 [SchemaValidator ] ERR...

Oracle Error PLS-00323: subprogram or cursor is declared in a package specification and must be defined in the package body?

Can someone help me put my pl/sql procedure in a package? I've tried and I'm struggling with it: This is what I hav...

Converting Long to Varchar2?

I am trying to insert into varchar2 column from a long column. here is the below example, TEXT.TEXT_COL = VARCHAR2(4...

ORACLE how to print text in a new line?

Basically its a letter printing in text I'm trying to do via an Oracle PL/SQL Procedure. My Code below: - DECLARE...