| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: How to find persons who like red fruits or crunchy veggies?
Tonkuma wrote:
> 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 ?
> For what dbd schema did you isuued this query? Would you show me exact
> definition of dbd schema?
Please don't encourage Neo. He has an experimental system he created himself. It is non-relational and "nonredundant" in the extreme. (e.g., he attempts to store the word red only once, whether it is used as the color of fruit to someones nickname or a terrorist status).
Do a google search in this group is you feel like browsing nonsense. Ed
Beware, there be trolls around here. Received on Thu Nov 16 2006 - 09:27:25 CST
![]() |
![]() |