Oracle 11gR2, an RDBMS product, is the second and terminal release of the Oracle 11g database.
Is there a way to pass column and table names dynamically to a query using bind variables? This could be …
sql oracle plsql oracle11gr2I am loading some data to Oracle via SQLLDR. The source file is "pipe delimited". FIELDS TERMINATED BY '|' …
oracle sql-loader oracle11gr2I am new to cx_oracle. I have established a connection and I am able to create and drop a …
python cx-oracle oracle11gr2I have a requirement to use the built in REPLACE function on a CLOB variable as part of a larger …
oracle plsql clob oracle11gr2DBMS_DATAPUMP doesn't fail when the columns in the source and destination tables do not match. This means that no …
oracle plsql oracle11gr2Objective Verify if it is true that insert records without PK/index plus create thme later is faster than insert …
oracle indexing insert database-performance oracle11gr2I have a table that contains a VARCHAR2 column called COMMANDS. The data in this column is a bunch of …
sql regex oracle oracle11g oracle11gr2The Oracle documentation claims that it stores XMLType more compact as BINARY XML than as CLOB. But how do I …
sql xml oracle oracle11gr2I 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