WITH clause and Depth First Search
In this article, I am going to explain how you can implement the depth first search with using the WITH clause or also known as subquery factoring clause. […]
More DetailsCategory: SQL
How to reorder columns of table
If you want to change the order of the columns of any table without recreating it, then the following trick will work for you. Suppose you want to […]
More Details5 Life Saving Features of Oracle
1) Partitioned Outer Join I would like to start with PARTITIONED OUTER JOIN. Because it is one of the least used feature. Suppose that you have two basic […]
More DetailsHow to generate, parse and use JSON data
In this article, I will explain how easily you can generate, parse and use JSON data in the Oracle database. I used Oracle 19c for all examples in […]
More DetailsUseful Oracle Functions
How to find the difference between two dates If you want to find the difference between two dates according to different time types, you can use the EXTRACT […]
More DetailsORA-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 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 Details