Title: RE: (ROSE) generate code (DDL) using Rose Data Model

Rose does not support objects with the Data-Modeler add-in. The closest you can come with Rose is to generate domains.

Regards,

Davor Gornik


-----Original Message-----
From: Prashant Pandey [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 1:42 AM
To: [EMAIL PROTECTED]
Subject: RE: (ROSE) generate code (DDL) using Rose Data Model


Can any body help me in finding the solution for the given below situation..

Actually I'm trying to generate code (DDL) for a table which is having "object" data type in Rational Rose.

For example:
object : (address)
    doorno    number
    street  varchar2(10)
...

table : Dept
   dno   number
   dname varchar2(50)
   loc    address
  ...

-----------------------------
Finally I have to get

create type address as object (
   doorno   number,
   street  varchar2(10),
..
)
/
create table dept (
  dno  number,
  dname varchar2(50),
  loc    address,
..
)
/
Regards
Prashant



Reply via email to