limit.sql

来自「Oracle 9i PL/SQL程序设计的随书源码」· SQL 代码 · 共 20 行

REM limit.sql
REM Chapter 8, Oracle9i PL/SQL Programming by Scott Urman
REM This block shows the LIMIT collection operator.

DECLARE
  v_Table NumTab := NumTab(1, 2, 3);
  v_Varray NumVar := NumVar(1234, 4321);
BEGIN
  -- Output the limit and count for the collections.
  DBMS_OUTPUT.PUT_LINE('Varray limit: ' || v_Varray.LIMIT);
  DBMS_OUTPUT.PUT_LINE('Varray count: ' || v_Varray.COUNT);
  IF v_Table.LIMIT IS NULL THEN
    DBMS_OUTPUT.PUT_LINE('Table limit is NULL');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Table limit: ' || v_Table.LIMIT);
  END IF;
  DBMS_OUTPUT.PUT_LINE('Table count: ' || v_Table.COUNT);
END;
/