Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: tranform xmltype contents to expression ?
"Abhinav" <matrix_calling_at_yahoo.dot.com> wrote in message
news:Q7ACc.35$Ab6.216_at_news.oracle.com...
> Hi ..
>
> I have the following sort of xml (In an xmlType in the database ..)
>
>
> <or_group>
> <operand>a</operand>
> <operand>
> <and_group>
> <operand>b</operand>
> <not_group>
> <operand>c</operand>
> </not_group>
> <and_group>
> </operand>
> </or_group>
>
> This needs to be evaluated as
> a+(b.(!c))
>
> Here, a/b/c are linked to functions which return true/false values, with
> the function taking some parameters.
>
> It is possible to do this by creating a linked list out of the tree, and
> evaluating in post fix using "native" planguages like C ..
>
> Would like to know if it is possible in PL/SQL .. or is it wishful
> thinking ?
>
> Any replies .. even if to say that it isnt possible .. appreciated :)
>
> Regards
> Abhinav
>
well, the PL in PL/SQL stands for Procedural Language. In fact PL/SQL
derives its syntax from ADA. So, if you know how to do it in C, you can do
it in PL/SQL, And yes, there is an XML parser callable from PL/SQL.
hth
rob van lopik
Received on Thu Jun 24 2004 - 10:32:34 CDT