Re: Avoiding any locks in SQL Servers - read and understand....its magic.

From: VC <boston103_at_hotmail.com>
Date: Tue, 27 Jan 2004 17:58:35 GMT
Message-ID: <eFxRb.163791$I06.1629053@attbi_s01>

Hello Niall,

See below:

• Original Message ----- From: "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc,comp.databases Sent: Tuesday, January 27, 2004 11:52 AM Subject: Re: Avoiding any locks in SQL Servers - read and understand....its magic.

> "VC" <boston103_at_hotmail.com> wrote in message
> news:jxwRb.163297$I06.1625632_at_attbi_s01...
> > Hello Galen,
> > "Galen Boyer" <galenboyer_at_hotpop.com> wrote in message
> > news:ud6955sg0.fsf_at_standardandpoors.com...
> > > On Mon, 26 Jan 2004, boston103_at_hotmail.com wrote:
> > >
> > > > Since Oracle does not have database constraints, one has to
> > > > code them manually as I did directly in the query.
> > >
> > > You basically lose all credibility when you make such
> > > statements. Why should anyone even try to make sense out of what
> > > you would want to show if you say such blatently incorrect things?
> > >
> >
> > Somehow I am not worried about my credibility. But, be a good chap,
> please
> > elaborate on such 'blatently' incorrect things, will you ?
> >
> > Thanks.
> >
> > VC

>

> I think you'd find that if you posted a definition of 'database
> constraints', you would find that you and Galen are just misunderstanding
> each other.

Ah, I see... I honestly could not figure out what he meant by "incorrect things" -- I just assumed that someone who tries to criticise so aggressivevly would have some familiarity with basic database concepts.

Anyway, traditionally the taxonomy is as follows:

o domain constraints -- not supported in 9i and below o table constraints -- partially supported (unique/referential/check) in 9i and below.
o database constraints or assertions (SQL-92) -- not supported in 9i and below.
 A database constraint relates to either a set of rows of a table, or the entire table, or a state required to exist among several tables.

VC

>

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
> ******************************************
>
> Received on Tue Jan 27 2004 - 11:58:35 CST