test.sql

oracle 全文检索的示例代码. 实现基于分区表的全文检索实现

drop table T_VAST_TIME;
create table T_VAST_TIME
(
  RES_SET_TIME INTEGER,
  RES_MIN_TIME INTEGER,
  RULE_ID      INTEGER,
  TNAME        VARCHAR2(100)
);


insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (30, 30, 1, 't_http,t_http_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (30, 30, 2, 't_ftp');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (30, 30, 3, 't_telnet,t_telnet_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (180, 30, 4, 't_email,t_email_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (360, 30, 5, 't_ims,t_ims_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (90, 30, 6, 't_wap,t_wap_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (30, 30, 8, 't_https,t_https_content');
insert into T_VAST_TIME (RES_SET_TIME, RES_MIN_TIME, RULE_ID, TNAME)
values (30, 30, 9, 't_game');

commit;
exit;