Use for loop to insert value to table collection and then use table collection in another insert statement : Table of Type « PL SQL « Oracle PL / SQL






Use for loop to insert value to table collection and then use table collection in another insert statement

    
SQL> CREATE TABLE MyTable (
  2    num_col    NUMBER,
  3    char_col   VARCHAR2(60)
  4    );

Table created.

SQL>
SQL>
SQL> DECLARE
  2    TYPE t_Numbers IS TABLE OF MyTable.num_col%TYPE
  3      INDEX BY BINARY_INTEGER;
  4    TYPE t_Chars IS TABLE OF MyTable.char_col%TYPE
  5      INDEX BY BINARY_INTEGER;
  6    v_Numbers t_Numbers;
  7    v_Chars t_Chars;
  8  BEGIN
  9    FOR v_Count IN 1..50 LOOP
 10      v_Numbers(v_Count) := v_Count;
 11      v_Chars(v_Count) := 'Row number ' || v_Count;
 12    END LOOP;
 13
 14    FORALL v_Count IN 1..50
 15      INSERT INTO MyTable VALUES
 16        (v_Numbers(v_Count), v_Chars(v_Count));
 17  END;
 18  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table MyTable;

Table dropped.

SQL>

   
    
    
  








Related examples in the same category

1.Create a function to convert string type variable to date type variable
2.Fetch a bulk into a table structure
3.Define a nested table type for each column
4.Extend once, outside the loop for better performance
5.A package to manage a list of employees
6.Fill table of custom type and use it in for loop to insert
7.Table of custome type indexed by BINARY_INTEGER
8.Reference type attribute through index
9.Use for loop to fill a table collection
10.Select bulk collect into
11.The EXISTS Table Attribute
12.FIRST & LAST Table Attributes
13.NEXT & PRIOR Table Attributes
14.Uses the COUNT method to display the number of rows contained in a table collection
15.How to do a bulk collect into a nested table.
16.How to do a bulk collect into an associative array
17.Table collection indexed by column type