可以,例子: DECLARE TYPE NumTab IS TABLE OF employees.employee_id%TYPE; TYPE NameTab IS TABLE OF employees.last_name%TYPE; enums NumTab; -- No need to initialize the collections. names NameTab; -- Values will be filled in by the SELECT INTO. BEGIN SELECT employee_id, last_name -- Retrieve data for 10 arbitrary employees. BULK COLLECT INTO enums, names FROM employees WHERE ROWNUM < 11; SELECT employee_id, last_name -- Retrieve approximately 20% of all rows BULK COLLECT INTO enums, names FROM employees SAMPLE (20);END;
DECLARE
TYPE NumTab IS TABLE OF employees.employee_id%TYPE;
TYPE NameTab IS TABLE OF employees.last_name%TYPE;
enums NumTab; -- No need to initialize the collections.
names NameTab; -- Values will be filled in by the SELECT INTO.
BEGIN
SELECT employee_id, last_name -- Retrieve data for 10 arbitrary employees.
BULK COLLECT INTO enums, names
FROM employees WHERE ROWNUM < 11; SELECT employee_id, last_name -- Retrieve approximately 20% of all rows
BULK COLLECT INTO enums, names
FROM employees SAMPLE (20);END;