Re: Check for no more than two entries of each value in a column?
From: livefreeordie <jpittman2_at_gmail.com>
Date: Tue, 21 Apr 2009 07:16:49 -0700 (PDT)
Message-ID: <bd23d6d1-fe85-4d5c-95a7-45e89f0f1cae_at_l5g2000vbc.googlegroups.com>
On Apr 20, 2:45 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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.
Date: Tue, 21 Apr 2009 07:16:49 -0700 (PDT)
Message-ID: <bd23d6d1-fe85-4d5c-95a7-45e89f0f1cae_at_l5g2000vbc.googlegroups.com>
On Apr 20, 2:45 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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.
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