|
SQL>
SQL> DECLARE
2 TYPE wordTableType IS TABLE OF VARCHAR2(50);
3
4
5 myTable1 wordTableType;
6
7
8 myTable2 wordTableType := wordTableType();
9 BEGIN
10 IF myTable1 IS NULL THEN
11 DBMS_OUTPUT.PUT_LINE('myTable1 is NULL');
12 ELSE
13 DBMS_OUTPUT.PUT_LINE('myTable1 is not NULL');
14 END IF;
15
16 IF myTable2 IS NULL THEN
17 DBMS_OUTPUT.PUT_LINE('myTable2 is NULL');
18 ELSE
19 DBMS_OUTPUT.PUT_LINE('myTable2 is not NULL');
20 END IF;
21 END;
22 /
myTable1 is NULL
myTable2 is not NULL
PL/SQL procedure successfully completed.
SQL>
SQL>
|