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 DetailsCategory: PL/SQL
How to convert CLOB to BLOB
Converting 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 DetailsHow to delete duplicate rows
Basically, 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 DetailsHow to use dynamic SQL with DBMS_SQL
There 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 DetailsCUME_DIST function
In 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 DetailsFOR UPDATE vs FOR UPDATE SKIP LOCKED
In 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 DetailsHow to use MULTISET UNION DISTINCT on collections
Let’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 DetailsHow to use PL/SQL functions within SQL
As 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 DetailsHow to make your PL/SQL code faster
In this post, some important points of PL/SQL performance metrics has been explained. Oracle 19c has been used in all examples. Use Bind Variable Using bind variables can […]
More DetailsPL/SQL Exception Handling in All Details
Exception management is one of the most important part of all programming languages. Having a good understanding of this topic will help you a lot in debugging. In […]
More Details