Oder Record wird intern definert
Tipp 57
Thema: DEKLARATION
Datenbank-Version: RDBMS 8.x
Erstellt am 07.10.19
Bearbeitet am 07.10.19
DECLARE
TYPE t IS RECORD (empno NUMBER, ename VARCHAR2(100));
my_t t;
FUNCTION f (
p_empno IN NUMBER,
p_ename IN VARCHAR2)
RETURN t IS
v_res t;
BEGIN
v_res.empno := p_empno;
v_res.ename := p_ename;
RETURN v_res;
END f;
BEGIN
my_t := f(7839,'KING');
DBMS_OUTPUT.PUT_LINE('ID='||my_t.empno||' Name= '||my_t.ename);
END;
/