|
SQL> DECLARE
2 TYPE hrc_company_rec IS RECORD
3 (hrc_company_id NUMBER,
4 product_description VARCHAR2(20),
5 company_short_name VARCHAR2(30));
6
7 TYPE hrc_company IS TABLE OF hrc_company_rec INDEX BY BINARY_INTEGER;
8
9 v_example_tab hrc_company;
10 BEGIN
11 /*Do some processing */
12 null;
13 END;
14 /
PL/SQL procedure successfully completed.
|