Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> objects and constraints

objects and constraints

From: Roland Winkler <rwinkler_at_esg-gmbh.de>
Date: Mon, 07 Feb 2000 07:57:53 +0100
Message-ID: <389E6CF1.613D211F@esg-gmbh.de>


Hi,

I want to model my Database with Objects, because every table has the same components. I will look like this:

Table A contains Objects a,c,d and other attributes, Table B includes Objects a,b,e and other attributes, ... and so on.

I have one Problem: I can't put constraint's like NOT NULL, Unique on objects and also Defaults, because it's a object and not a table.

So when I create all Tables with this Objects I don't want to create the

constraint's all the time. In PL/SQL I can't use DDL, so in which way can I
automate this problem?

Thanks

Roland Received on Mon Feb 07 2000 - 00:57:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US