Creating a diagram for Oracle object types
From: Kevin B <kbass1_at_nc-rr.com>
Date: Thu, 26 Oct 2000 21:58:16 GMT
Message-ID: <YN1K5.766$G95.156138_at_typhoon.southeast.rr.com>
CREATE OR REPLACE TYPE PERSON_TY AS OBJECT
(
);
/
);
Date: Thu, 26 Oct 2000 21:58:16 GMT
Message-ID: <YN1K5.766$G95.156138_at_typhoon.southeast.rr.com>
I have constructed some object types in Oracle and have attempted to create an ER Diagram but cannot see the object types that I have created (using ERWin). Are there any tools that will identifiy objects types within diagrams?
An example of my Oracle object type and table accessing the object.
CREATE OR REPLACE TYPE PERSON_TY AS OBJECT
(
person_fname VARCHAR2(35), person_lname VARCHAR2(35), person_desc VARCHAR2(80), person_login_id VARCHAR2(35), person_email_adrs_desc VARCHAR2(80), person_paswd VARCHAR2(35)
);
/
CREATE TABLE PERSON
(
person_oid VARCHAR2(35) NOT NULL, usr_oid VARCHAR2(80) NOT NULL, person_desc PERSON_TY
);
Thanks!!
Kevin Received on Thu Oct 26 2000 - 23:58:16 CEST