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

From: joel garry <>
Date: Mon, 20 Apr 2009 11:45:12 -0700 (PDT)
Message-ID: <>

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.


-- is bogus.
Oracle buys Sun:
No white knight from Andromeda galaxy, I guess.
Received on Mon Apr 20 2009 - 13:45:12 CDT

Original text of this message