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: How to find persons who like red fruits or crunchy veggies?

Re: How to find persons who like red fruits or crunchy veggies?

From: Neo <neo55592_at_hotmail.com>
Date: 15 Nov 2006 14:57:22 -0800
Message-ID: <1163631442.453951.246300@h54g2000cwb.googlegroups.com>


> In your language, can you query:
> How many fruit colors are there? [Yes]
> Which fruit color(s) is/are the most liked? [No]
> How many veggies are there that nobody likes? [No]

Currently dbd's NLI (SQL-type) interface implements very basic functions such as create, select, update and delete (and a few others listed at www.dbfordummies.com/NLI/function.asp).

Even modest functions such as MIN, MAX, etc would need to be implemented by application interfacing to a db via API. See www.dbfordummies.com/example/ex010b.asp which generates a nearest common ancestor report for things in a hierarchy.

Below are the closest queries that dbd can perform via its NLI:

(; Count fruits)
(count (select fruit instance *))

(; Count colors for fruits)
(count (and (select color instance *)

                 (select (select fruit instance *) color *)))

(; Find veggies somebody likes)
(and (select veggie instance *)

       (select (select person instance *) like *)) Received on Wed Nov 15 2006 - 16:57:22 CST

Original text of this message

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