Select bulk collect into : Table of Type « PL SQL « Oracle PL / SQL

Select bulk collect into

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

Table created.

SQL>
SQL> DECLARE
  2    TYPE t_Numbers IS VARRAY(10) OF MyTable.num_col%TYPE;
  3    v_Numbers t_Numbers;
  4  BEGIN
  5    SELECT num_col
  6      BULK COLLECT INTO v_Numbers
  7      FROM MyTable;
  8  END;
  9  /

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL> drop table MyTable;

Table dropped.

SQL>
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.	Use for loop to insert value to table collection and then use table collection in another insert statement
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