Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to filter on keywords in hierarchical tables?
Oracle SQL chalange:
Suppose you have a hierarchy
ODER_GROUP (OG_ID, ...)
ORDER (OG_ID, O_ID, ...)
ORDER_LINE (OG_ID, O_ID, OL_ID, DESCRIPTION, ...)
You want to construct a dynamic SQL (say in Visual Basic) where you
want a list or order groups (no duplicates of course) for which there
are order lines that have any of a given set of keywords in the
description.
How to do this in Oracle SQL?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Oct 04 1999 - 13:14:35 CDT