aa_types.pks

来自「OReilly Oracle PL SQL Programming第4版源代码」· PKS 代码 · 共 48 行

CREATE OR REPLACE PACKAGE aa_types
IS
   TYPE boolean_aat IS TABLE OF BOOLEAN
    INDEX BY BINARY_INTEGER;
 
   TYPE date_aat IS TABLE OF DATE
    INDEX BY BINARY_INTEGER;
 
   TYPE integer_aat IS TABLE OF INTEGER
    INDEX BY BINARY_INTEGER;
 
   TYPE pls_integer_aat IS TABLE OF PLS_INTEGER
    INDEX BY BINARY_INTEGER;
 
   TYPE binary_integer_aat IS TABLE OF BINARY_INTEGER
    INDEX BY BINARY_INTEGER;
 
   TYPE natural_aat IS TABLE OF NATURAL
    INDEX BY BINARY_INTEGER;
 
   TYPE positive_aat IS TABLE OF POSITIVE
    INDEX BY BINARY_INTEGER;
 
   TYPE number_aat IS TABLE OF NUMBER
    INDEX BY BINARY_INTEGER;
 
   TYPE maxdbvarchar2_aat IS TABLE OF VARCHAR2(4000)
    INDEX BY BINARY_INTEGER;
 
   TYPE maxvarchar2_aat IS TABLE OF VARCHAR2(32767)
    INDEX BY BINARY_INTEGER;
 
   TYPE identifier_aat IS TABLE OF VARCHAR2(30)
    INDEX BY BINARY_INTEGER;
 
   TYPE utl_file_aat IS TABLE OF UTL_FILE.FILE_TYPE
    INDEX BY BINARY_INTEGER;
 
   TYPE xml_aat IS TABLE OF XML_TYPE
    INDEX BY BINARY_INTEGER;
 
   TYPE clob_aat IS TABLE OF CLOB
    INDEX BY BINARY_INTEGER;
 
   TYPE blob_aat IS TABLE OF BLOB
    INDEX BY BINARY_INTEGER;
END aa_types;
/