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 DetailsHow to use XMLTABLE
XMLTABLE is a powerful feature in Oracle databases that transforms XML data into relational format for easy querying. I would like to begin with comprehensive example. In the […]
More DetailsHow to implement wait spinner in APEX dynamic action
So, the easiest way to implement showing a spinner in a dynamic action is as follows. Let’s implement it in Apex. I created a button called btnRun and […]
More DetailsHow to list all privileges of a user
If you’re looking to learn all the privileges granted to a specific user, you can utilize the following data dictionary tables. Additionally, you have the option to utilize […]
More DetailsHow to create or alter a job
So, basically, you can use the following code to create a job. If you want to modify the REPEAT_INTERVAL attribute of a job, you can use the DBMS_SCHEDULER.SET_ATTRIBUTE […]
More DetailsHow 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 DetailsORA-01704 string literal too long
ORA-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 Details