Overview This document is about how to add or remove columns from the input table based on the parameters you pass in oracle. Technologies and Tools Used The following technologies have been used to…
Read MoreOverview : The process of generating an Excel file and sending it as an email attachment using PL/SQL packages in Oracle Apex is a powerful solution for automating the task…
Read MoreOverview : Oracle Apex is a powerful platform for rapid application development that enables developers to create dynamic web applications effortlessly. The advanced customization of LOV items in Oracle Apex…
Read MoreOverview This document says about how to load multiple data files with csv format using sql loader from UNIX and also explains about control file and database connection through Linux.…
Read MoreOverview 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 More