Posted inAPEX
Data loading utility in Oracle APEX
COLLECTION Step 1: Create Data Loading Definition Step 2: Select Target Type (COLLECTION Name- DATA_LOADING) Step 3: Sample Data Mapping (Source Type - Upload a File/Copy and Paste) Step 4:…
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…
ORA-06531: Reference to uninitialized collection PLSQL
ORA-06531: Reference to uninitialized collection Error Description:Reference to uninitialized collection Error Cause:An element or member function of a nested table or varray was referenced (where an initialized collection is needed) without…
PLSQL Collection Data Deletion
PLSQL collection data deletion CREATE OR REPLACE TYPE l_rec_type IS OBJECT (id NUMBER, name VARCHAR2 (1111)); / CREATE OR REPLACE TYPE l_tab_type IS TABLE OF l_rec_type; / Copy CodeCopiedUse a…