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: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)

From: Neo <neo55592_at_hotmail.com>
Date: 25 May 2004 11:37:04 -0700
Message-ID: <4b45d3ad.0405251037.45e21496@posting.google.com>


> > > How ... extracts just the record for "John Smith"...
> >
> > (person) "john smith"
>
> Aha ... This would extract the "record" which identifies "John Smith"?
> Including, name, rank, social security number, shoe size,
> and anything else stored along with the identifier?

Yes, it finds the thing which represents John Smith. From that thing, remaining data can be retrieved. Below is simplified psuedo code to find him and print his SSN:

   pT = X("(person) 'john smith'");
   pSSN = T_Val_get(pT, pSSN_Cls);
   str = T_Name(pSSN);
   print(str);

Some functions (ie X, T_Val_get) can return 0 to many things thus the following programming structure is typical:

  while (pT = X("(person) 'john smith'")){     // Process current person
  } Received on Tue May 25 2004 - 13:37:04 CDT

Original text of this message

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