ORACLE Query

From: <nayakviv_at_my-dejanews.com>
Date: Thu, 29 Apr 1999 20:31:23 GMT
Message-ID: <7gafir$4ha$1@nnrp1.dejanews.com>

Hi ,

I have to create a table of person skills. This table would have all the skills associated with a person.

columns in the table would be
person_name
skill_name
skill_level

e.g of entries would be

mike, oracle , 7
mike, unix , 5
mike, c, 8
john , oracle , 5
john , unix , 8

john , java , 7
john , C++, 9

The feature that is to be implemented is that i want to query this table for all persons with a specified skill set e.g 1. oracle and unix and C 2. oracle and unix and ( java or C++ )

and so on .

What is the best way to write the query . Is it possible and if not , how to design the table .

Regards
Vivek

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 29 1999 - 15:31:23 CDT