Collection Constructor Including Null Elements
DECLARE
TYPE dnames_tab IS TABLE OF VARCHAR2(30);
dept_names DNAMES_TAB;
TYPE dnamesnonulls_type IS TABLE OF VARCHAR2(30) NOT NULL;
BEGIN
dept_names := Dnames_tab('Shipping',NULL,'Finance',NULL);
-- If dept_names was of type dnamesNoNulls_type, we could not include
-- null values in the constructor
END;
/
Posts
0 comments:
Post a Comment