NVL vs COALESCE
As it is known, NVL and COALESCE functions are used in order to eliminate NULL values. However, NVL function is much more popular in comparison with the COALESCE. […]
More DetailsAs it is known, NVL and COALESCE functions are used in order to eliminate NULL values. However, NVL function is much more popular in comparison with the COALESCE. […]
More DetailsLet’s start with a basic example. Suppose, you have two PL/SQL collections with the same data type that you want to merge and remove the repetitive data. You […]
More DetailsAs it is known, invoking PL/SQL code from SQL cause context switching. SQL is a non-procedural language and it is very different from PL/SQL language. In addition, PL/SQL […]
More DetailsMATCH_RECOGNIZE is one of the most powerful feature of SQL. There are several use cases, such as finding series of consecutive rows, pattern matching, etc. Once you understand […]
More DetailsIf you consider to aggregate data from multiple rows into a single column, LISTAGG might be the first function that comes to your mind. It has been enhanced […]
More DetailsIn 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 DetailsIf 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 Details1) 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 DetailsIn 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 DetailsHow 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 Details