CREATE OR REPLACE TYPE subordonati_*** AS VARRAY(10) OF NUMBER(4);
/
CREATE TABLE manageri_*** (cod_mgr NUMBER(10),
nume VARCHAR2(20),
lista subordonati_***);
DECLARE
v_sub
subordonati_***:= subordonati_***(100,200,300);
v_lista manageri_***.lista%TYPE;
BEGIN
INSERT INTO manageri_***
VALUES (1, 'Mgr 1', v_sub);
INSERT INTO manageri_***
VALUES (2, 'Mgr 2', null);
INSERT INTO manageri_***
VALUES (3, 'Mgr 3', subordonati_***(400,500));
SELECT
INTO
FROM
WHERE
lista
v_lista
manageri_***
cod_mgr=1;
FOR j IN v_lista.FIRST..v_lista.LAST loop
DBMS_OUTPUT.PUT_LINE (v_lista(j));
END LOOP;
END;
/
SELECT * FROM manageri_***;