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 DetailsIn 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 DetailsIn rare cases we might need to convert string data into rows. So, you can simply do this using the code below. If your string is not comma […]
More DetailsAdaptive 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 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 DetailsWe 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 DetailsPIVOT 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 DetailsWhen 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 DetailsIn the previous article, I mentioned about pipelined table functions. In this article, I am going to talk about parallel feature of pipelined table functions. At least one […]
More DetailsTable functions are used in FROM clause of a query as if it were a regular table that return PL/SQL collections. Returning large size of collections can be […]
More DetailsIn brief, I will compare the equivalence of SQL, XQuery and XPATH. The following XML feed is used for this purpose. Oracle 11g is used. Now, I want […]
More Details