Dynamic Table name

[rdhiravani]

Hi,
I want a variable table name in a procedure.
I thought some IN parameters can be passed like
procedure may receive a varchar table name or a number deciding which table to use for fetching data.

is it possible?

Waiting for reply.

Thanks in advance.

[debasisdas]

Yes that is very much possible to do in oracle using PL/SQl.
for that u need to use dynamic SQL using EXECUTE IMMEDIATE.