| Range [message #570926] |
Sun, 18 November 2012 22:26  |
|
|
Hi , can we make a search based on column , actually i have one requirement where the data is stored in column as comma seperated values like below
arif,123455,123456,77777
sait,123455,123456,66666
tomm,666666,123455,123456
I want to filter only 123455 and 123456 from this list, is it possible to get a range as i want to use it as report parameters , i can do it by using like operator as below
create table prd_mast ( prd_cd varchar2(12), prd_desc varchar2(3000));
insert into prd_mast values ('1','arif,123455,123456,77777');
insert into prd_mast values ('2','sait,123455,123456,66666');
insert into prd_mast values ('3','tomm,666666,123455,123456');
insert into prd_mast values ('4','tomm,666666,123444,123444');
commit
select prd_cd from prd_mast where prd_desc like '%123455%' or prd_desc like '%123456%';
Thanks
Arif
|
|
|
|
|
|
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
