tag:blogger.com,1999:blog-4129346287195722005.post5643032112420682347..comments2024-03-10T22:04:19.953-07:00Comments on ThinkTibits!: Oracle SQL XMLCast extractvalue Example TutorialAnonymoushttp://www.blogger.com/profile/07717408059667602415noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4129346287195722005.post-15251446999379317522017-08-15T11:19:55.765-07:002017-08-15T11:19:55.765-07:00If your xml is using namespaces, you may need to a...If your xml is using namespaces, you may need to add a namespace declaration in front of your path. If you use xmlns, this is the syntax: 'declare default element namespace "http://www.your.domain/path"; /book/main/pages' passing u_val returning content) as varchar2(100)) "REFERENCE" from xmlcast_test;Anonymoushttps://www.blogger.com/profile/03345405607331639663noreply@blogger.comtag:blogger.com,1999:blog-4129346287195722005.post-14815297264568570922016-10-12T06:59:03.534-07:002016-10-12T06:59:03.534-07:00I get no results with the following query:
SELECT...I get no results with the following query: <br />SELECT XMLCast(XMLQuery('/book/main/pages' PASSING U_VAL RETURNING CONTENT) AS<br /> VARCHAR2(100)) "REFERENCE"<br /> FROM XMLCAST_TEST<br /><br />any help please?<br />I am using Oracle 12cAnonymousnoreply@blogger.com