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 -> Re: Development Trends in Web and Oracle

Re: Development Trends in Web and Oracle

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 14 Mar 2005 23:32:43 +1100
Message-ID: <4235846b$0$21030$5a62ac22@per-qv1-newsreader-01.iinet.net.au>


Mark C. Stock apparently said,on my timestamp of 14/03/2005 10:56 PM:

> Simple validation can be handled with constraints, and sometimes with a
> combination of function based indexes and UK constraints, but quite a few
> business rules must be enforced via triggers on the tables or a PL/SQL code
> in a trigger API.

There were NO business rules in the example given as a "great XML invention". All I saw were very basic data definition constraints. I am perfectly aware of what can be done with PL/SQL triggers, thank you very much.

> XML Schema validation handles some things DRI and constraints cannot
> (patterns, min/max members of a set) and DRI handles some things DRI cannot.

Unfortunately, true.

-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Mon Mar 14 2005 - 06:32:43 CST

Original text of this message

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