How 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 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 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 Details