Re: ORACLE Query

This cries out for relational tables :

[ Note not actual code follows, just representational ]

Create Table Person_data (
person_name,
person_id primary key )

Create Table Skill_Data (
Skill_name,
Skil_Pers_key foreign key referencing Person_data.person_id )

Then your could do:

Select person_name, skill_name from
person_data p,skill_Data s
where
p.pereson_id = s.Skil_Pers_key
order by person_name;

 This way, all skills that are related to that person will be displayed....

Hope it provides some ideas...

nayakviv_at_my-dejanews.com wrote:

>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 .
Received on Thu Apr 29 1999 - 15:52:47 CDT