关于PL/SQL的初级问题!程序为什么不执行?
DECLARE
TYPE my_chartable IS TABLE OF VARCHAR2(6);
MyNultable my_chartable;
MyEmptable my_chartable:=my_chartable();
BEGIN
IF MyNultable IS NULL THEN
DBMS_OUTPUT.PUT_LINE('MyNultable IS NULL');
ELSE
DBMS_OUTPUT.PUT_LINE('MyNultable IS NOT NULL');
END IF;
IF MyEmptable IS NULL THEN
DBMS_OUTPUT.PUT_LINE('MyEmptable IS NULL');
ELSE
DBMS_OUTPUT.PUT_LINE('MyEmptable IS NOT NULL');
END IF;
END;
这是一段关于嵌套表的程序,在sql plus中输入
SQL>@d:\test.sql
执行上面那段程序但结果是:
SQL> @d:\myjob\test.sql
19
20
SQL>
20后面的SQL>是我ctrl c强行退出的结果,否则程序肯定处于不执行状态