Dynamic variable creation in oracle:

See more:

Oracle

Dynamic variable creation in oracle:

I dont know is it accurate question which i want to ask:

Bassicly i want to create variable at run time: like this:

select * from table t where t.name in ("here i dont know the number of values, and can be insert at run time");

my complete problem is, I was given multiple values in decimel format, first i have to convert these values in HAX format manually and then concate some of these values and then put it in query, I want to automate this whole process in oracle, say when i run procedure it ask me for values in decimle(number of values unknown) then procedure convert these values in HAX and some of these values concatinate and then insert it in query.
How can i accomplish this task.