DECLARE
TYPE t_ca_varchar2 IS TABLE OF VARCHAR2(100);
t_names t_ca_varchar2 := t_ca_varchar2();
BEGIN
WITH tb AS
(SELECT last_name
FROM hr.employees)
SELECT last_name BULK COLLECT
INTO t_names
FROM tb
WHERE rownum < 50;
IF SQL%FOUND THEN
dbms_output.put_line(SQL%ROWCOUNT);
END IF;
TYPE t_ca_varchar2 IS TABLE OF VARCHAR2(100);
t_names t_ca_varchar2 := t_ca_varchar2();
BEGIN
WITH tb AS
(SELECT last_name
FROM hr.employees)
SELECT last_name BULK COLLECT
INTO t_names
FROM tb
WHERE rownum < 50;
IF SQL%FOUND THEN
dbms_output.put_line(SQL%ROWCOUNT);
END IF;
END;
输出
49;