PL/SQL Brain Teaser -- Shouldnt be too difficult for an expert

From: DG <programguru_at_hotmail.com>
Date: 5 Feb 2003 07:21:38 -0800
Message-ID: <5c45388c.0302050721.268dcb7f@posting.google.com>

This can only be done in PL/SQL.

I have a table with two fields. Each value has a corresponding priority number with it. A sample table is below:

Values, Priorities

a1       1
a2       15
a3       10

.
.

a15 2

I am passing 30 arguments to a procedure. They are as follows: (value1, priority1, value2, priority2......., value15, priority15) These values will update the table above, however i need to make sure that all priorities are unique.

What is the best way to determine that there are no duplicate priority numbers?  

Any ideas how to go about this? Received on Wed Feb 05 2003 - 09:21:38 CST