Home » Server Options » Text & interMedia » Need to get the one specific record with 's (oracle 11.2.0.4)
Need to get the one specific record with 's [message #667005] Tue, 05 December 2017 01:42 Go to previous message
mvrkr44
Messages: 131
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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: where to check context index sync status
Next Topic: How to escape reserved words returned in column values as parameters to CONTAINS function
Goto Forum:
  


Current Time: Sun Aug 09 18:44:32 CDT 2020