Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

existsNode Vs XMLexists in Oracle SQL

Rajneesh S-OracleFeb 25 2020 — edited Feb 25 2020

Hello All,

I am using existsNode as below:

select existsNode(t.viewdef,'/functionalView/where')

                 from xml_data t

Wanted to explore if XMLexists performs same action? if so then what is difference and use cases to clearly distinguish these two?

Thanks,

Rajneesh
This post has been answered by mNem on Feb 25 2020
Jump to Answer
Comments
Post Details
Added on Feb 25 2020
16 comments
2,912 views