|
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
Term: EXTRACTVALUE
Definition: SELECT EXTRACTVALUE(OBJECT_VALUE, '/Orders/MailAddressTo/Company') The SQL query below returns the value existing on XPath /Orders/MailAddressTo. But note that the query fails because the XPath contains subcode. SELECT EXTRACT_VALUE(OBJECT_VALUE, '/Invoice/MailAddressTo') AS MailAddressTo Related Links: |
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2024 psoug.org |