title: Difference between object and record type
body: <p>I am just curious whats the difference between object and record type in oracle, More specifically between the below declarations</p>
  
  <pre><code>create type emp2_oty is object 
  (
   empno  number,
   ename  varchar2(20),
   deptno number
  );
  
  create type emp2_nt is table of emp2_oty;
  </code></pre>
  
  <p>and </p>
  
  <pre><code>type emp2_oty is record
  (
   empno  number,
   ename  varchar2(20),
   deptno number
  );
  
  create type emp2_nt is table of emp2_oty;
  </code></pre>
  
  <p>Please elaborate.</p>