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



**************************Disclaimer************************************************** 
   
 
 Information contained in this E-MAIL being proprietary to Wipro Limited is 
'privileged' 
and 'confidential' and intended for use only by the individual or entity to which it 
is 
addressed. You are notified that any use, copying or dissemination of the information 
contained in the E-MAIL in any manner whatsoever is strictly prohibited.

****************************************************************************************



Reply via email to