Q] What's the differ from 3 types of "CREATE"?

From: ksjune <ksjune_at_sys.gsnu.ac.kr>
Date: Fri, 09 Jul 1999 15:35:42 +0900
Message-ID: <3785983E.BADA813E@sys.gsnu.ac.kr>

Hi!!!.
I'd like to know difference of 3 type of create table statements. Please Help.

1.=============================================

SQL> create table employee
  2 (
  3 id number,
  4 first_name varchar2(10),
  5 last_name varchar2(10),
  6 ssn varchar2(11)
  7 );
Table created.

2.=============================================

SQL> create type emp_name as object (
  2 first_name varchar2(10),
  3 last_name varchar2(10)
  4 );
  5 /
Type created.
SQL> create table employee2
  2 (
  3 id number,
  4 name emp_name,
  5 ssn varchar2(11)
  6 );
Table created.

3.========================================

SQL> create type emp as object
  2 (
  3 id number,
  4 name emp_name,
  5 ssn varchar2(11)
  6 );
  7 /
Type created.
SQL> create table employee3 of emp;
Table created.

---

Question) I know #1 create statement(relational table). And Have no OID.
But do not know different #2 from #3.
Is Employee2 table objct table?

Please Help!!!!

mailto:ksjune_at_sys.gsnu.ac.kr Received on Fri Jul 09 1999 - 01:35:42 CDT