clob okuma

1 declare
2 t clob;
3 my_vr varchar2(200);
4 i1 number;
5 begin
6 i1 := 200;
7 select text into t from doc_table where rowid='AAAWsCAAJAAA/AaAAC';
8 dbms_lob.read(t,i1,1,my_vr);
9 dbms_output.put_line(my_vr);
10* end;
Surface treatment for improved hardness and corrosion resistance - Patent
6497772

Patent Number:
Advanced Search
Site Contents
Search Patents
Use our
search engine to find what you need
Syntax Ref

Sozluk yaratma

ctxload -user ctxsys/ctxsyssifre@orasid -thes -thescase y -name nstc -file nstc.thes

begin
 Ctx_Thes.Drop_Thesaurus (
   name => 'mythes' );
end;
/

select ths_owner, ths_name from ctx_thesauri;

Kelime Aydınlatma

create table markup_tab (query_id number, document clob);

set pagesize 1000
set long 10000
begin
ctx_doc.markup(index_name => 'temp_text_idx',
textkey => 'AAAWsCAAJAAA3G0AAI',
text_query => 'sqe(ships)',
restab => 'markup_tab',
query_id => '1',
tagset =>'HTML_DEFAULT');
end;

select document from markup_tab;

Örnek sonuç:

...its fleet of ships from marine micro-organism "Fouling", the coating techn...