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

Home -> Community -> Usenet -> c.d.o.server -> objects

objects

From: Roland Winkler <rwinkler_at_okay.net>
Date: Sun, 06 Feb 2000 19:03:50 +0100
Message-ID: <389DB786.AFFB76C3@okay.net>


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 in 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 Sun Feb 06 2000 - 12:03:50 CST

Original text of this message

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