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

Home -> Community -> Usenet -> c.d.o.server -> How to filter on keywords in hierarchical tables?

How to filter on keywords in hierarchical tables?

From: <p_m_hegt_at_hotmail.com>
Date: Mon, 04 Oct 1999 18:14:35 GMT
Message-ID: <7taqpv$crh$1@nnrp1.deja.com>


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

Original text of this message

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