Oracle PL/SQL Tutorial/Collections/Table of Number
Содержание
- 1 Accessing an entire Index-by table
- 2 Accessing an Index-by table
- 3 Accessing an undefined row of an Index-by table
- 4 Accessing Nested Table elements
- 5 An example of COUNT method
- 6 An example of declaring an Index-by table
- 7 An example of the DELETE method
- 8 An example of the FIRST, LAST and NEXT methods
- 9 Assigning rows of an Index-By table by means of a LOOP
- 10 Associative arrays
- 11 compare two tables of integers
- 12 Deleting an Index-by table using an empty Index-by table
- 13 Initialize table collection with null value
- 14 Initializing a Nested Table
- 15 Is a table collection a null value
- 16 Loop through table of number by index
- 17 NULL and Empty Nested Tables and NULL elements
- 18 number_list.EXTEND(2): Add two null value members at the end of the list.
- 19 number_list.EXTEND(3,4): Add three members at the end of the list and copy the contents of item 4
- 20 ORA-06531: Reference to uninitialized collection
- 21 ORA-06533: Subscript beyond count
- 22 Using the EXISTS method
Accessing an entire Index-by table
SQL> DECLARE
2 TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3 myTable1 num_tab;
4 myTable2 num_tab;
5 v_num NUMBER :=13;
6 BEGIN
7 myTable1(1):=1001;
8
9 myTable1(10):=1002;
10
11 myTable1(-10):=1003;
12
13 myTable1(v_num):=1004;
14
15 myTable2 :=myTable1;
16
17 dbms_output.put_line(to_char(myTable2(1))||" "||
18 to_char(myTable2(10))||" "||
19 to_char(myTable2(-10))||" "||
20 to_char(myTable2(v_num)));
21 END;
22 /
1001 1002 1003 1004
PL/SQL procedure successfully completed.
Accessing an Index-by table
SQL> DECLARE
2 TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3 myTable num_tab;
4 v_num NUMBER :=13;
5 BEGIN
6 myTable(1):=1001;
7 myTable(10):=1002;
8 myTable(-10):=1003;
9 myTable(v_num):=1004;
10
11 dbms_output.put_line(to_char(myTable(1))||" "||
12 to_char(myTable(10))||" "||
13 to_char(myTable(-10))||" "||
14 to_char(myTable(v_num)));
15 END;
16 /
1001 1002 1003 1004
PL/SQL procedure successfully completed.
Accessing an undefined row of an Index-by table
SQL> DECLARE
2 TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
3 myTable num_tab;
4 v_num NUMBER :=13;
5 BEGIN
6 myTable(1):=1001;
7 myTable(10):=1002;
8 myTable(-10):=1003;
9 myTable(v_num):=1004;
10 dbms_output.put_line(to_char(myTable(100)));
11 END;
12 /
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 10
<topic title="Sample code using exception while accessing an undefined row of an Index-by table">
<code><