How to use LONG column in the WHERE clause
As developers, we often query the data dictionary for details about views, triggers, and other objects. Oracle stores large text data like object definitions in LONG columns, which […]
More DetailsCategory: PL/SQL
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 DetailsHow 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 Details