Home » SQL & PL/SQL » SQL & PL/SQL » Table Name as Parameter in Function
Table Name as Parameter in Function [message #37796] Thu, 28 February 2002 07:17 Go to next message
Panneer Selvam
Messages: 7
Registered: November 2001
Junior Member
Hi

How to pass a table name as an IN parameter in a function .

Select count(*) from p_table_name

Here p_table_name is the input parameter
Re: Table Name as Parameter in Function [message #37798 is a reply to message #37796] Thu, 28 February 2002 07:24 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
u have to use dynamic pl/sql
DBMS_SQL package
OR
EXECUTE IMMEDIATE
Previous Topic: Deafult Parameter
Next Topic: Trigger firing when it shouldn't
Goto Forum:
  


Current Time: Fri Mar 29 07:33:34 CDT 2024