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 DetailsXMLTABLE 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 DetailsSo, 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 DetailsIf 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 DetailsSo, 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 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 Details