Top "Oracle11gr2" questions

Oracle 11gR2, an RDBMS product, is the second and terminal release of the Oracle 11g database.

passing table and column name dynamically using bind variables

Is there a way to pass column and table names dynamically to a query using bind variables? This could be …

sql oracle plsql oracle11gr2
SQL*Loader: Dealing with delimiter characters in data

I am loading some data to Oracle via SQLLDR. The source file is "pipe delimited". FIELDS TERMINATED BY '|' …

oracle sql-loader oracle11gr2
INSERT not working in cx_oracle when used with execute. How to get it working?

I am new to cx_oracle. I have established a connection and I am able to create and drop a …

python cx-oracle oracle11gr2
Why does using REPLACE function on CLOB cause increase in CACHE_LOBS...?

I have a requirement to use the built in REPLACE function on a CLOB variable as part of a larger …

oracle plsql clob oracle11gr2
How do you make DBMS_DATAPUMP error if there's an error?

DBMS_DATAPUMP doesn't fail when the columns in the source and destination tables do not match. This means that no …

oracle plsql oracle11gr2
Oracle 11G - Performance effect of indexing at insert

Objective Verify if it is true that insert records without PK/index plus create thme later is faster than insert …

oracle indexing insert database-performance oracle11gr2
Return all matches of a regular expression in Oracle

I have a table that contains a VARCHAR2 column called COMMANDS. The data in this column is a bunch of …

sql regex oracle oracle11g oracle11gr2
How big is an Oracle XMLType when stored as BINARY XML

The Oracle documentation claims that it stores XMLType more compact as BINARY XML than as CLOB. But how do I …

sql xml oracle oracle11gr2
ORA-04091: table SCMA.XX is mutating, trigger/function may not see it

I have two tables- XX and YY with their triggers calling each other in case of an update. The trigger …

oracle plsql triggers oracle11gr2 mutating-table