Hi,
How can get elements from table "a" and "b" into a table "c". I could write a loop but I don't know if there is a smarter option:
DECLARE
TYPE t IS TABLE OF NUMBER;
a t;
b t;
c t;
BEGIN
a := t(1,2,3);
b := t(3,4,5);
c := ... -- c {1, 2, 3, 3, 4, 5}
END;
I could use something like this but I would prefer define table type in a package:
CREATE OR REPLACE TYPE t AS TABLE OF NUMBER;
SELECT a MULTISET UNION b INTO c FROM dual;
Thanks in advance