OraFAQ Forum: JDeveloper, Java & XML

Home » Developer & Programmer » JDeveloper, Java & XML » Oracle11g (Need help on XMLTYPE )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle11g [message #665838]

Tue, 26 September 2017 00:30

ssyr
Messages: 65
Registered: January 2017

Member

HI all,

Can you please provide me suggestion me below query I want to truncate query upto 512 bytes, how can I do this?
When I am running this query it is not executing how can I execute this query?

select  extractvalue(xmltype(rr.extended_attributes),'/Map/String[@key="affiliate"]/text()') 
from  rest rr

Please give me suggestion

Thanks in Advance.

Report message to a moderator

[Message index]

		Oracle11g By: ssyr on Tue, 26 September 2017 00:30
		Re: Oracle11g By: _jum on Tue, 26 September 2017 00:50
		Re: Oracle11g By: ssyr on Tue, 26 September 2017 01:03
		Re: Oracle11g By: _jum on Tue, 26 September 2017 02:31

Previous Topic:	data extraction from xmltype
Next Topic:	How Can I Call Rdf Report,and 11g form through Jsp Pages in Oracle Jdeveloper

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 03:58:25 CDT 2024