© 2023 Hashnode
#plsql
PL/SQL is a procedural language that overcomes the shortcomings faced by Structured Query Language. So, why do we need PL/SQL when we have SQL? SQL is a query language. It is not a functional language…
Need to download a file from an APEX page but not sure how? Before you write your own custom PL/SQL procedure that requires setting HTTP headers and uses sys.WPG_DOCLOAD.download_file or HTP.PRN to output content, consider using APEX_DATA…
PL/SQL blocks are groups of one or more SQL or PL/SQL statements that are enclosed within a BEGIN and END block. PL/SQL variables are used to store values that can be referenced and manipulated within a PL/SQL block. Here is an example of a…
PL/SQL (Procedural Language/Structured Query Language) is an extension of SQL that enables developers to write procedural code and implement business logic within an Oracle database. Here are some of the key topics to learn in PL/SQL: PL/S…
Importing large amounts of data into a database can be a challenging task, but with the help of PL/SQL, it can be a smooth and efficient process. In this tutorial, we'll walk you through creating a Ma…
Introduction Last week, apex.oracle.com has been upgraded to Oracle APEX 23.1 letting us play with the new features built with ❤ by the APEX team. One of them is new Execution Chain process type that …
Introduction In almost every Oracle APEX application, we need to set up authorization schemes to manage access to pages, buttons, processes, etc... This post will explain how it is possible to build a…
Quite some time ago I was asked by a customer how we could track the changes to a row over time. They had a couple of very important tables for which they wanted to keep track of who changed what. The…
There are many times when you're coding an application where there is a requirement for seed data that is required for the system to run correctly. If the seed data is changed or missing, some program…
Somewhere around version 9 (maybe before, maybe later…all so long ago 😀) the distinction between CLOB and VARCHAR2 became less defined. This was a good thing because the typical operations you would …