Does anyone have experience using inso filters for all kind of documents for 2004-05-19 - By Juan Cachito Reyes Pacheco
Thanks
My problem is the following
I want to get the line where the text serach is
For example serachibng Oracle you get
Doc1 ...... Oracle Corporation is a business.....
Doc2 ...Oracle database is currently 10g.....
etc.
There is a command, but in a blob storing a pdf document I get unreadable
text
SQL > declare
2 resarr ctx_query.browse_tab;
3 begin
4
ctx_query.browse_words( 'SEARCH_IDX ', 'Database ',resarr,10,CTX_QUERY.BROWSE_A
ROUND);
5 for i in 1..resarr.count loop
6 dbms_output.put_line(resarr(i).word || ': ' || resarr(i).doc_count);
7 end loop;
8 end;
9 /
SQL > set serveroutput on
SQL > /
9,999.99i:1
999,999,999:1
999,999,999,999:1
99999999999:1
9999999999S:1
DATABASEADMINISTRATOR:1
DATABASEADMINISTRATORiS:1
?1
?-:1
?2
If you know how to do it using Oracletext or Oracle Ultasearch please
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
