Re: Check for no more than two entries of each value in a column?

From: livefreeordie <>
Date: Tue, 21 Apr 2009 07:16:49 -0700 (PDT)
Message-ID: <>

On Apr 20, 2:45 pm, joel garry <> wrote:
> On Apr 18, 5:04 am, livefreeordie <> wrote:
> > Wow thanks for all the suggestions.  I understood about 20% of what
> > you all said - I believe I'll go with the materialized view.  Will
> > this work in Oracle 8?
> > Jamie
> Yes, but not all the options mentioned earlier are available.  You
> need to understand it 100%, and it can be a bit daunting at first if
> you have no DBA help available.  The fact you are asking about 8 is a
> very bad sign.  If it is not or later (IIRC, there were later
> minor patches for specific issues), also called the terminal release,
> you are asking for trouble, and even there you are asking for
> trouble.  Probably a good thing you didn't mention the version at the
> beginning, you would likely have gotten no help at all.  You need to
> always be specific about versions so people can give good answers.
> You might want to download XE to your PC and do this in Apex. Then you
> can make it so pretty with so little effort you can get people to fix
> your version problem.

Yeah unfortunately I'm just a "user" on someone else's Oracle server. The company I work for is extremely slow to upgrade versions for fear of breaking stuff.

Jamie Received on Tue Apr 21 2009 - 09:16:49 CDT

Original text of this message