Need to get the one specific record with 's [message #667005] |
Tue, 05 December 2017 01:42 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
On : 11.2.0.4 version, RDBMS
create table test1(id number,names varchar2(1000));
create index idx_names on test1(names) indextype is ctxsys.context;
insert into test1 values(1,'test record');
insert into test1 values(2,'raj''s record');
insert into test1 values(3,'raj record');
insert into test1 values(4,'raj ecord');
insert into test1 values(5,'raj');
commit;
after inserting record i am running the below block.
begin
ctx_ddl.sync_index('idx_names');
end;
/
select * from test1 where contains(names,'raj''s',1)>0
i am getting the all 2,3,4,5 records ..actually i need to get only 2 record.
How can i achive this one.?
Regards,
Rajesh
|
|
|