How to convert BLOB to CLOB
Ever wondered how to turn pictures or other binary data back into readable text in Oracle PL/SQL? Let’s explore the easy steps of converting BLOB (Binary Large Object) […]
More DetailsEver wondered how to turn pictures or other binary data back into readable text in Oracle PL/SQL? Let’s explore the easy steps of converting BLOB (Binary Large Object) […]
More DetailsConverting text data from CLOB to BLOB can be tricky. Let’s explore how to make that conversion. I used the function with UTF-8 character set. Additionally, if you […]
More DetailsBasically, there are several ways to do this. In this post, I show two different ways. Let’s start with a basic example. Set Up Checking if the table […]
More DetailsThere may be situations where we need to run dynamic queries in our developments. We can utilize execute immediate statement or DBMS_SQL package in order to use dynamic […]
More DetailsORA-01704 error occurs when a string literal more than 4000 characters in SQL. In the example below the string length is exactly 4000 characters. So, if one character […]
More DetailsIn this post, I am going to explain how to correct the cardinality estimate in 5 different methods. Cardinality estimate is one of the first place to check […]
More DetailsIn this post, I would like to explain a function that is not well known. CUME_DIST analytic function is used for calculating the cumulative distribution of a data […]
More DetailsIn this post, I am going to explain how FOR UPDATE and FOR UPDATE SKIP LOCKED clauses work. I would like to demonstrate it with a basic example. […]
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 Details