OraFAQ Forum: Text & interMedia » xml search + single quote handling (merged)

Home » Server Options » Text & interMedia » xml search + single quote handling (merged)

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

xml search + single quote handling (merged) [message #356516]

Thu, 30 October 2008 23:55

gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai

Member

i m using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

i want to search in xml
i have this query

SELECT /*+ FIRST_ROWS INDEX(p I01_GPAPR_010_FULL) */
P.DATA_ID_DATE,
P.DATA_ID_SEQ,
P.DATA_VERSION,
P.DATA.GETCLOBVAL()
FROM GPAPR_010_KREDIT_ABLAGE_DAT P
WHERE CONTAINS(DATA,'((a'b WITHIN Kr_Fo_Container_Nr )) WITHIN OrderAttributes') > 0
AND ROWNUM <= 100
ORDER BY P.ARCHIVE_TIMESTAMP DESC

i m not allowed to search for a'b so i change it to a''b
but it returns me value in xml which contains

i get two output
a'b
a b

so can any one tell me how to handle single quote(') in xml select query.

Report message to a moderator

[Message index]

		xml search + single quote handling (merged) By: gaikwadrachit on Thu, 30 October 2008 23:55
		Re: single quote handling By: Michel Cadot on Fri, 31 October 2008 01:45
		Re: xml search + single quote handling (merged) By: Barbara Boehmer on Fri, 31 October 2008 16:54

Previous Topic:	Problems with CTX_DOC.SNIPPET on HTML documents
Next Topic:	BFile content index And Network Share

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 07:11:42 CDT 2024