Overview This document talks about how Qualified Expressions for Associative Array works before and after the oracle 18c version. Technologies and Tools Used The following technologies has been used to…
Read MoreINTRODUCTION: PL/SQL stands for Procedural Language/Structured Query Language. PL/SQL offers a set of procedural commands (IF statements, loops), organized within blocks, that complement and extend the reach of SQL. PL/SQL is…
Read MoreIntroduction: For displaying the Blob content in the column in interactive grid, we don’t have a predefined column type for blob content display. This can be implemented using custom solution…
Read MoreStep 1: Get the hash value of the SQL using the SQL ID. Enter the SQL ID select a.plan_hash_value from v$sql a where sql_id=’&a’; Step 2: Create a tuning…
Read MoreWhen we are doing the operations like upgrades, patches, and DDL changes the associated schema objects will get invalid. So it is difficult to recompile all the user objects one…
Read MoreIntroduction Play sound is used to play audio files in Oracle Forms, Play Sound plays the sound object in the specified sound item PLAY_SOUND examples The following plsql block you…
Read MoreOverview Inline external tables enable the run time definition of an external table to be part of a SQL statement, thus eliminating the need to create an external table as…
Read MoreOverview This topic provides examples of how to load CSV files from external tables under various conditions. Some of the examples build on previous examples. Technologies and Tools Used The…
Read MoreOverview The LISTAGG aggregate function now supports duplicate elimination by using the new DISTINCT keyword. The LISTAGG aggregate function orders the rows for each group in a query according to…
Read MoreThe easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…
Read More