| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> How to find persons who like red fruits or crunchy veggies?
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 ? Received on Tue Nov 14 2006 - 23:16:09 CST
![]() |
![]() |