sql - Show LIKE condition matches in a column -

i have similar query:

select fname, lname names gcode %5536% or fname %3663% 

there 50 conditions this, , terms bit longer, general idea. can't make temporary tables route we're going.

i make trying return condition output matched on in own column (i.e., have %5536% returned in own column)

i can highlight programmatically, there way in sql?

you can store match conditions in collection:

select n.fname,        n.lname,        t.column_value match   name n        inner join        table( sys.odcivarchar2list( '%5536%', '%3663%' ) ) t        on ( n.gcode t.column_value );