{"id":5846,"date":"2014-04-07T09:38:31","date_gmt":"2014-04-07T09:38:31","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/04\/07\/problem-about-oracle-text-collection-of-common-programming-errors\/"},"modified":"2014-04-07T09:38:31","modified_gmt":"2014-04-07T09:38:31","slug":"problem-about-oracle-text-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/04\/07\/problem-about-oracle-text-collection-of-common-programming-errors\/","title":{"rendered":"problem about oracle-text-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/882cd324218e4e884f8fdeba729a8a7e?s=32&amp;d=identicon&amp;r=PG\" \/><br \/>\nPetr Mensik<br \/>\nsql oracle oracle10g oracle-text<br \/>\nIs there any performance difference between dbms_lob.instr and contains or am I doing something wrong?Here is my codeSELECT DISTINCT ha.HRE_A_ID, ha.HRE_A_FIRSTNAME, ha.HRE_A_SURNAME, ha.HRE_A_CITY, ha.HRE_A_EMAIL, ha.HRE_A_PHONE_MOBIL FROM HRE_APPLICANT ha WHERE ha.HRE_A_STATUS_ID=1 AND ha.HRE_A_CURRENT_STATUS_ID &lt;= &#8216;7&#8217; AND ((DBMS_LOB.INSTR(hre_a_for_search,&#8217;java&#8217;) &gt; 0) OR EXISTS (SELECT 1 FROM gob_attachment, gob_table WHERE hre_a_id=gob_a_record_id AND gob_a_table_id = gob_t_id AN<\/li>\n<\/ul>\n<p>Web site is in building<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Petr Mensik sql oracle oracle10g oracle-text Is there any performance difference between dbms_lob.instr and contains or am I doing something wrong?Here is my codeSELECT DISTINCT ha.HRE_A_ID, ha.HRE_A_FIRSTNAME, ha.HRE_A_SURNAME, ha.HRE_A_CITY, ha.HRE_A_EMAIL, ha.HRE_A_PHONE_MOBIL FROM HRE_APPLICANT ha WHERE ha.HRE_A_STATUS_ID=1 AND ha.HRE_A_CURRENT_STATUS_ID &lt;= &#8216;7&#8217; AND ((DBMS_LOB.INSTR(hre_a_for_search,&#8217;java&#8217;) &gt; 0) OR EXISTS (SELECT 1 FROM gob_attachment, gob_table WHERE hre_a_id=gob_a_record_id AND gob_a_table_id [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-5846","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5846","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=5846"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/5846\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=5846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=5846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=5846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}