*** I have posted the same message in Oracle Development forum.
I am developing an application in pro*C and Oracle.
I want to create a table that has a multi-valued column, meaning can hold more than one value.
My problem is this:
1) I thought about using a varchar2 type and contcatenating values through pro*C, but when i perform a select clause, i will have to use like %someting% and that will cause a full table scan.
2) I thought about using object type, but i know oracle holds the object as lob type and i cant query the lob type for its contents.

What do i do ???