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 -> Re: Avoiding any locks in SQL Servers - read and understand....its magic.

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

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 27 Jan 2004 16:52:02 -0000
Message-ID: <40169733$0$16730$cc9e4d1f@news.dial.pipex.com>


"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. It is not unreasonable to claim that Oracle does provide 'database constraints' since they are listed in dba_constraints :(. I know that that isn't what you are referring to but googling the phrase 'database constraints' throws up this usage as well as papers on RDBMS theory.

--
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 - 10:52:02 CST

Original text of this message

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