I am new to this forum. But anyway I have serious question to ask about.

I have a table say Restaurant i.e.
Sql> desc restaurant
phone_number number(10);
cusine_type varchar2(20);

Phone number is the primary key for this table.
The data looks like this:

4082220010 1,2,3,4,5
4081111111 2,3,8,9

I have many cusine types which are identifed by id's
i.e. '1' stands for chinese
'2' stands for 'mexican'
'3' stands for 'italian' etc.
I have another table which keeps the cusinetype ids
i.e.
SQL>desc attributes
attribute_id number;
attribute_type varchar2(20);
This has the values like this;
1 chinese
2 mexican
3 italian
etc.
If I delete id 2 from attributes table, I have to delete 2 from
cusine_type string of restaurant. In my previous example
both restaurants has 2 in their cusine type.
So i have to delete 2 from cusine type and the data now becomes
4082220010 1,3,4,5
4081111111 3,8,9
So the real problem here is parsing for that particular value and then removing it from it.

Any inputs on this is greatly appreciated.

Thanks