Showing posts with label Defining - Bulk Binding in Native Dynamic SQL. Show all posts
Showing posts with label Defining - Bulk Binding in Native Dynamic SQL. Show all posts

Thursday, October 4, 2012

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;