?? colltypes.pks
字號:
CREATE OR REPLACE PACKAGE collection_types
IS
-- Associative array types
TYPE boolean_aat IS TABLE OF BOOLEAN
INDEX BY BINARY_INTEGER;
TYPE date_aat IS TABLE OF DATE
INDEX BY BINARY_INTEGER;
TYPE pls_integer_aat IS TABLE OF PLS_INTEGER
INDEX BY BINARY_INTEGER;
TYPE number_aat IS TABLE OF NUMBER
INDEX BY BINARY_INTEGER;
TYPE identifier_aat IS TABLE OF VARCHAR2(30)
INDEX BY BINARY_INTEGER;
TYPE vcmax_aat IS TABLE OF VARCHAR2(32767)
INDEX BY BINARY_INTEGER;
-- Nested table types
TYPE boolean_ntt IS TABLE OF BOOLEAN;
TYPE date_ntt IS TABLE OF DATE;
TYPE pls_integer_ntt IS TABLE OF PLS_INTEGER;
TYPE number_ntt IS TABLE OF NUMBER;
TYPE identifier_ntt IS TABLE OF VARCHAR2(30);
TYPE vcmax_ntt IS TABLE OF VARCHAR2(32767);
END collection_types;
/
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -