ORA-30926 unable to get a stable set of rows in the source tables
In this post, I am going to talk about ORA-30926 error and how to solve it. Let’s create the following tables for our example. This error occurs due […]
More DetailsHow to split comma separated string into rows
In some cases, we may need to convert string data into rows. You can use the following methods to achieve this. 1. Regular Expressions One of the first […]
More DetailsAdaptive Cursor Sharing & Histograms
Adaptive cursor sharing has been used in Oracle 11g first. This feature enables a single statement that contains bind variables to use multiple execution plans. According to the […]
More DetailsAnalytic functions & Windowing clause
Analytic functions have been used from the early versions of Oracle. It is used in many tasks, especially reporting. In this article, I am going to use EMP […]
More DetailsUnlock Apex admin account
You can find the lock accounts from the following query. So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block. You […]
More DetailsSUBSTR vs DBMS_LOB.SUBSTR
We have to choose the right built-in function when developing pl/sql applications. The following test case shows the performance outcome between SUBSTR and DBMS_LOB.SUBSTR functions. This test was […]
More DetailsPrint clob data with htp.prn
As it is known, HTP.PRN procedure does not support clob data. None of the HTP.PRN procedures shown in below support CLOB data type as input. So, the following […]
More DetailsIn-Doubt Transactions and ORA-02049 timeout distributed transaction waiting for lock
Distributed transactions perform DML on multiple databases. If any issue occurs during this transaction such as network or system problems etc. The transaction becomes in-doubt. Normally, Oracle’s RECO […]
More DetailsPivot and Unpivot Operators in Oracle 11g
PIVOT In this article you will learn how to use PIVOT and UNPIVOT operators. Basically, pivot operator allow you to transpose rows into columns. Prior to 11g, it […]
More DetailsORA-22859 invalid modification of columns
When you try to convert datatype CLOB to VARCHAR2, you get the ORA-22859 invalid modification of columns error even if the column is empty. In order to overcome […]
More Details