Type object and object table

From: Zaida Chora <jzach_at_esoterica.pt>
Date: Sun, 28 Nov 1999 12:37:14 -0000
Message-ID: <943792222.159764_at_orodruin.esoterica.pt>

Hi
I need some help to work with objects.
[Quoted] I have a type cpost and a related table cpostal.

CREATE TYPE cpost AS OBJECT
(codchave NUMBER(8),

  cpostal      NUMBER (7),
  design       VARCHAR2(50));

CREATE TABLE cpostal OF cpost;

I have another type person that references cpost

CREATE TYPE person AS OBJECT
(codigo NUMBER (9),

  nome      VARCHAR2 (90),
  edrua      VARCHAR2 (60),

  edcpost REF cpost);

CREATE TABLE people OF person;

How can I insert a record in people having a edcpost that exists in cpostal ??
 thanks

Zaida Received on Sun Nov 28 1999 - 13:37:14 CET