set echo on

drop index lib_index;
drop table test_table;
exec ctx_ddl.drop_section_group('mysg');

create table test_table 
  (id number primary key, 
   month_info clob);

insert into test_table values (1, '022003');
insert into test_table values (2, '082003');
insert into test_table values (3, '072003');
insert into test_table values (4, '012003');
insert into test_table values (5, '122003');
insert into test_table values (6, '122003');
insert into test_table values (7, '082003');
insert into test_table values (8, '032003');
insert into test_table values (9, '022003');
insert into test_table values (10, '092003');
insert into test_table values (11, '102003');
insert into test_table values (12, '112003');
insert into test_table values (13, '032003');
insert into test_table values (14, '032003');
insert into test_table values (15, '012003');
insert into test_table values (16, '092003');

exec ctx_ddl.create_section_group(group_name=>'mysg', group_type=>'xml_section_group');

exec ctx_ddl.add_mdata_section(group_name=>'mysg', section_name=>'month', tag=>'month');

create index lib_index on test_table (book_info)
indextype is ctxsys.context 
parameters ('section group mysg');

select err_text from ctx_user_index_errors where err_index_name = 'LIB_INDEX';

column book_info format a30

select score(1), book_info from test_table 
where contains (month_info, '

  
    
       mdata(month, 122003) 
       mdata(month, 112003) 
       mdata(month, 102003) 
       mdata(month, 092003) 
       mdata(month, 082003) 
       mdata(month, 072003) 
       mdata(month, 062003) 
       mdata(month, 052003) 
       mdata(month, 042003) 
       mdata(month, 032003) 
       mdata(month, 022003) 
       mdata(month, 012003) 
   
 

',1) > 0 and rownum <= 5;