The Oracle PL/SQL EXISTSNODE keyword is an XML Type member function which is used to check valid nodes corresponding to the specified XPath. It searches specific values at the node level. Essentially, EXISTSNODE determines whether or not the traversal of an XML document using a given path will result in any nodes. It returns one of the BOOLEAN values TRUE or FALSE.
The EXISTSNODE function is deprecated. It is still supported for backward compatibility, however, Oracle recommends that you use the XMLEXISTS
The SELECT statement below checks an Order node in the ORDERS_XML table. It checks whether mail has been sent to a vendor by checking that whether or not the path "/Order/MailAddressTo/Company" exists for the condition "Company=Google".
object_value, '/Order/MailAddressTo[Company="Google"]') = 1;