Home » SQL & PL/SQL » SQL & PL/SQL » XML search
XML search [message #355742] Mon, 27 October 2008 05:42 Go to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
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 have one query which return the XMl row which contain a+b
but when i fire this query i get same answer which is wrong it should not return any row

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
Re: XML search [message #355751 is a reply to message #355742] Mon, 27 October 2008 06:16 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:
Michel Cadot wrote on Tue, 21 October 2008 11:41
As already requested to you:
read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Use SQL*Plus and post what you tried.

Regards
Michel

Previous Topic: pl/sql is it object oriented..... newbie question...
Next Topic: problem with one up number
Goto Forum:
  


Current Time: Fri Dec 09 03:44:36 CST 2016

Total time taken to generate the page: 0.08505 seconds