Re: Check for no more than two entries of each value in a column?
Date: Mon, 20 Apr 2009 11:45:12 -0700 (PDT)
Message-ID: <d9c89a9e-84b2-4ece-a2db-361b0c05d7f5_at_v35g2000pro.googlegroups.com>
On Apr 18, 5:04 am, livefreeordie <jpittm..._at_gmail.com> 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 8.1.7.4 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.
jg
-- _at_home.com is bogus. Oracle buys Sun: http://www.oracle.com/sun/index.html No white knight from Andromeda galaxy, I guess.Received on Mon Apr 20 2009 - 13:45:12 CDT