Data loading utility in Oracle APEX

COLLECTION Sample Data Loading into Table Create a table for loading data. Demo #JoelKallmanDay  Read more

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 OF NUMBER INDEX BY VARCHAR2(10); l_tab l_tab_type; Variable-size array or... Read more

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 the collection having been initialized. Action:Initialize the collection with an appropriate... Read more

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; / Read more