Member Avatar for 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.

  • 2 Contributors
  • 1 Reply
  • 69 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.