Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to find persons who like red fruits or crunchy veggies?

Re: How to find persons who like red fruits or crunchy veggies?

From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 15 Nov 2006 16:27:03 -0800
Message-ID: <1163636822.974888.76970@m73g2000cwd.googlegroups.com>


kvnkrkptrck_at_gmail.com wrote:
> In your language, can you query:
> How many fruit colors are there? Which fruit color(s) is/are the most
> liked? How many veggies are there that nobody likes?

How about relational division type of queries?

i) find all job applicants who have all the skills (or find pilots that can fly all the airplans)

ii)
table sets (

    set# integer,
    element integer
)

e.g. {{1,2,3},{3,4}}
set# element
---- ---------
1 1
1 2
1 3
2 3
2 4

find the intersection of the sets (i.e. all the elements that belong to all the sets). Received on Wed Nov 15 2006 - 18:27:03 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US