Retrieve an individual column object from a table

CREATE TABLE emp(
   emp t_emp,
   dept INTEGER
);


CREATE TYPE t_emp AS OBJECT (
   id INTEGER,
   name VARCHAR2(10),
   sal NUMBER(5, 2),
   hiredate DATE,
   MEMBER FUNCTION get_hire_date RETURN DATE
);
/

CREATE TYPE BODY t_emp AS
   MEMBER FUNCTION get_hire_date RETURN DATE IS
      v_date DATE;
   BEGIN
      SELECT hiredate INTO v_date FROM dual;
      RETURN v_date;
   END;
END;
/


INSERT INTO emp (emp,dept) VALUES (t_emp(1, 'Peter', 20, '17-DEC-1980'),50);


SQL> SELECT p.emp
  2  FROM emp p
  3  WHERE p.emp.id = 1;

EMP(ID, NAME, SAL, HIREDATE)
------------------------------------------------

T_EMP(1, 'Peter', 20, '17-DEC-80')

SQL>