How 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 DetailsHow to fix cardinality misestimate?
In 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 Details