Posted inORACLE PLSQL

PLSQL Collection

PL/SQL provides three collection types − Index-by tables or Associative array Syntax TYPE type_name IS TABLE OF element_type [NOT NULL] INDEX BY subscript_type; table_name type_name; Example TYPE l_tab_type IS TABLE…
Posted inAPEX

APEX Page Access Protection

Oracle APEX provides various types of Page access protection (Page level declarative). We can utilize them as per the required scenario. Let’s see all of um one by one ……
Posted inAPEX

APEX_SESSION.ATTACH

APEX_SESSION ATTACH Procedure In my previous blog , I have shared the way to query APEX_COLLECTIONS data from database backend itself. That approach needs to follow three steps. Setting up Workspace Setup…
Posted inAPEX

Installing Oracle APEX 21

Installing APEX 21.1 Oracle APEX Dev team announced the APEX 21.1 on May 12 2021. Let’s get it installed and running. Step 1 Download Step 2 Extract Step 3 Create PDB for…
Posted inAPEX SQL

APEX_LANG

APEX_LANG.MESSAGE API is a great fit for translating messages in APEX. Here we can define a message for each desired language like en, fr etc. MESSAGE function is very useful…
Posted inAPEX PLUGINS

Why APEX Plugins?

Why APEX Plugins? Oracle application express or widely known as APEX is a great framework that comes up with endless possibilities. Forms, Reports flexible and responsible designs which help to…