Home » SQL & PL/SQL » SQL & PL/SQL » Range (Oracle 10g Reports 6i)
Range [message #570926] Sun, 18 November 2012 22:26 Go to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

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
Re: Range [message #570927 is a reply to message #570926] Sun, 18 November 2012 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
does NOT conform to Third Normal Form & is doomed to be fatally flawed.

Re: Range [message #570928 is a reply to message #570927] Sun, 18 November 2012 23:33 Go to previous messageGo to next message
arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

OK
Re: Range [message #570933 is a reply to message #570928] Mon, 19 November 2012 01:22 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read Normalization.

Regards
Michel
Previous Topic: SQL Error: ORA-00911: invalid character - HELP!
Next Topic: Using nvl within a sum
Goto Forum:
  


Current Time: Mon Oct 20 20:23:50 CDT 2014

Total time taken to generate the page: 0.11245 seconds