XML : how can i query a value in xml column for oracle server

I have following XML stored in a NCLOB column (called Roles) in a oracle database.

             <root>               <role>Alpha</role>               <role>Beta</role>               <role>Gamma</role>             </root>    

I'd like to list all rows that have a specific role in them. This role can be passed by parameter.

No comments:

Post a Comment