写个自定义过程,代码如下: SQL> CREATE OR REPLACE PROCEDURE is_list_empty AS 2 TYPE nestedTableType IS TABLE OF VARCHAR2(10); 3 myTable1 nestedTableType; 4 result BOOLEAN; 5 BEGIN 6 myTable1 := nestedTableType('F', 'G', 'S'); 7 result := myTable1 IS EMPTY; 8 IF result THEN 9 DBMS_OUTPUT.PUT_LINE('Nested table is empty'); 10 ELSE 11 DBMS_OUTPUT.PUT_LINE('Nested table contains elements'); 12 END IF; 13 END is_list_empty; 14 /