Difference between object and record type

Question

I am just curious whats the difference between object and record type in oracle, More specifically between the below declarations

create type emp2_oty is object  (  empno  number,  ename  varchar2(20),  deptno number );  create type emp2_nt is table of emp2_oty; 

and

type emp2_oty is record (  empno  number,  ename  varchar2(20),  deptno number );  create type emp2_nt is table of emp2_oty; 

Please elaborate.

Answer 1

• record:

     Cannot be stored in the database.    Cannot be recursively referenced.    Cannot have logic defined as part of their definition. 

• object:

     Can be stored as a database table column or as an entire row.    Can be recursively referenced using the SELF parameter.    Can have logic defined as part of their definition using member methods.