| wild card search on CLOB not giving require result in 12C [message #638325] |
Tue, 09 June 2015 08:58  |
panot4u
Messages: 5
Registered: September 2006
|
Junior Member |
|
|
Issue :- There is a CLOB Column (which is divided into section groups) on which we are doing blank wild card searching , which is not working and give the record which are not match to search criteria and this searching is gave proper result in Oracle 11 G.
==============================================================================================
Query For 12C :-
==============================================================================================
select indexedmetatext from n1_1433376000_1433462400 where contains(indexedmetatext,'((( ( % within BZ ) ) or ( ( % within BY ) )) and (sdata(isprotocolname = ''http'')) )')>0
OutPut :- All rows are coming , present in table;
==============================================================================================
Query for 11g
==============================================================================================
select /*+ index ( v2_1430784000_1438560000 ( indexedmetatext)) */ indexedmetatext from v2_1430784000_1438560000 where contains(indexedmetatext,'((( ( % within BZ ) ) or ( ( % within BY ) )) and (sdata(isprotocolname = ''http'')) )')>0
OutPut :- only one row come .
Help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
