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: <michael_at_preece.net>
Date: 15 Nov 2006 19:50:15 -0800
Message-ID: <1163649015.305859.256130@b28g2000cwb.googlegroups.com>

Neo wrote:
> The following dbd query finds persons who like either red fruits or
> crunchy veggies:
>
> (and (select person instance *)
> (select * like (or (and (select fruit instance *)
> (select * color red))
> (and (select veggie instance *)
> (select * texture crunchy))
> )
> )
> )
>
> What RMDB schema and SQL query will find the equivalent? Should I start
> with T_Person, T_Fruit, T_Veggie, T_PLikeF, T_PLikeV ?

I like tomatoes. Imagine a world without them. No ketchup. No pizza base. Are they fruit or veges? They're not especially crunchy though anyway. What about red capsicums? Are they crunchy veges or fruit? Received on Wed Nov 15 2006 - 21:50:15 CST

Original text of this message

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