Tell me, please, how to display the xmltype value. for example

select xmlelement(b) from ( select xmltype('<cover> <title>Oracle SQL*Loader</title> <author>Jonathan Gennick</author> <author>Sanjay Mishra</author> <pages>269</pages> </cover>') b from dual )

Required for use in the request (((Procedural decisions on the Internet have

  • Not entirely clear: for display or for use in a query? "Procedural decisions on the Internet are" - and what they are, not for the sake of curiosity, but for a better understanding of what you really need. - 0xdb 7:42 pm

2 answers 2

This is how you can get the value of xmlType :

 with data as ( select xmlType (' <cover> <title>Oracle SQL*Loader</title> <author>Jonathan Gennick</author> <author>Sanjay Mishra</author> <pages>269</pages> </cover>') b from dual ) select dbgetClobVal () from data d ;

    Maybe you mean this:

     SELECT * FROM TABLE(xmlsequence(xmltype('<cover> <title>Oracle SQL*Loader</title> <author>Jonathan Gennick</author> <author>Sanjay Mishra</author> <pages>269</pages> </cover>').extract('//title')))