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: Gray Hair is still relevant

Re: Gray Hair is still relevant

From: Neo <neo55592_at_hotmail.com>
Date: 9 Jul 2006 16:14:24 -0700
Message-ID: <1152486864.722443.106250@s13g2000cwa.googlegroups.com>


> "Let's say I have a table of users, and each user has a list of categories....get a full list of everyone's categories without duplicates.

Below is how a dummy could do it:

(new 'cat)

(new 'john)
(create john cat (val+ 'person))

(new 'mary)
(create mary cat (val+ 'person))
(create mary cat (val+ 'engineer))

(new 'bob)
(create bob cat (val+ 'person))
(create bob cat (val+ 'engineer))
(create bob cat (val+ 'pilot))

(; Following query returns person, engineer and pilot without
duplicates)
(select cat instance *)

See www.dbfordummies.com for more details. Received on Sun Jul 09 2006 - 18:14:24 CDT

Original text of this message

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