| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Nearest Common Ancestor Report (XDb1's $1000 Challenge)
> > > 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
![]() |
![]() |