Category Archives: Defining – Bulk Binding in Native Dynamic SQL

Defining – Bulk Binding in Native Dynamic SQL

Consider a program to populate elements of a PL/SQL collection from a SELECT query thus… declare   type employee_ids_t is table of employees.employee_id%type     index by binary_integer;     employee_ids employee_ids_t; n integer:=0; begin   for j in ( select … Continue reading

Posted in Defining - Bulk Binding in Native Dynamic SQL, PL/sql Collection | Leave a comment