Object Tables

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;
/


SQL> CREATE TABLE emp OF t_emp;

Table created.

SQL>

SQL> INSERT INTO emp VALUES (t_emp(1, 'Peter', 395,'17-DEC-1980'));

1 row created.

SQL>

Or to insert the values in the same way with a relational table. 

SQL> INSERT INTO emp(id, name, sal, hiredate) VALUES (2, 'Jack', 299,'17-DEC-1980');

1 row created.

SQL>
SQL>
SQL> SELECT * FROM emp;

        ID NAME              SAL HIREDATE
---------- ---------- ---------- ---------
         1 Peter             395 17-DEC-80
         2 Jack              299 17-DEC-80

SQL>
SQL>

Select specify individual object attributes in a query:

SQL> SELECT id, name, sal FROM emp op WHERE id = 1;

        ID NAME              SAL
---------- ---------- ----------
         1 Peter             395

SQL>