help me to get values of a table having only one column into one variable

[kaviyarasan]

I have a table called COLUMN_VALUE which has only one column. Inside a procedure, I like to check whether chkmp(this is field name of other table) is equal to any of the values of column_value... help me

[debasisdas]

You simply need to check the same using IN.

[amitpatel66]

How are you going to pass the input to the procedure? Delimited (Comma,or any other) or collections?