INDEX BY TABLE 记录索引表

 

/* Formatted on 2012/02/22 18:30 (Formatter Plus v4.8.7) */

CREATE TABLE test_index_by_table_beke(

my_name VARCHAR2(25),

age NUMBER,

creation_date DATE,

created_by NUMBER,

last_update_date DATE,

last_update_by NUMBER,

last_update_login NUMBER,

my_id NUMBER

)

CREATE TABLE test_index_by_table_beker(

my_name VARCHAR2(25),

age NUMBER,

creation_date DATE,

created_by NUMBER,

last_update_date DATE,

last_update_by NUMBER,

last_update_login NUMBER,

my_id NUMBER

)

/* Formatted on 2012/02/22 18:31 (Formatter Plus v4.8.7) */

CREATE SEQUENCE test_index_by_table_beke_s

START WITH 1

INCREMENT BY 1;

/* Formatted on 2012/02/22 18:31 (Formatter Plus v4.8.7) */

INSERT INTO test_index_by_table_beker

(creation_date,

last_update_date,

my_id

)

VALUES (SYSDATE,

SYSDATE,

test_index_by_table_beke_s.NEXTVAL

);

/* Formatted on 2012/02/22 18:29 (Formatter Plus v4.8.7) */

DECLARE

TYPE test_tab_type IS TABLE OF test_index_by_table_beke%ROWTYPE

INDEX BY BINARY_INTEGER;

my_test_table test_tab_type;

v_count NUMBER (3) := 5;

BEGIN

FOR i IN 1 .. v_count

LOOP

SELECT *

INTO my_test_table (i)

FROM test_index_by_table_beker

WHERE my_id = i;

END LOOP;

FOR i IN my_test_table.FIRST .. my_test_table.LAST

LOOP

DBMS_OUTPUT.put_line (my_test_table (i).my_id);

END LOOP;

END;

 

output：

 

1

2

3

4

5