Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
<<demo_block>> declare XMLDOC CLOB; url VARCHAR2(100); BEGIN select XMLDOC into demo_block.XMLDOC from xml_documents where extract(xmltype(XMLDOC),'/digital/state/city[@mayor_name=SMITH]') is not null; url := extract('/digital/state/city[@mayor_name=SMITH]').getStringVal; DBMS_OUTPUT.PUT_LINE(url); END;
|Two Oracle Queries - Different Results - Why?||9||50|
|Extracting data for test table||2||35|
|find difference between dates from a column in oracle||9||40|
|Adding a blank row when using union all||4||36|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
14 Experts available now in Live!