Home » SQL & PL/SQL » SQL & PL/SQL » Dynamically generating Table and Column name
Dynamically generating Table and Column name [message #37895] Tue, 05 March 2002 08:32 Go to next message
kiran kumar
Messages: 17
Registered: June 2001
Junior Member
Is it possible to pass both Table name and Column name as parameter to the procedure if so

how does procedure look like .

my requirement is something like

create or replace procedure (tablename varchar2 ,colname varchar2)
begin
select &colname from &tablename;
end;

Thanks in advance,
kiran
Re: Dynamically generating Table and Column name [message #37899 is a reply to message #37895] Tue, 05 March 2002 09:48 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
You use dynamic SQL to handle this. This example uses native dynamic SQL (NDS) available in 8i and above:

create or replace procedure my_proc
  (tablename in varchar2, colname in varchar2)
is
  v_value  varchar2(255);
begin
  execute immediate 'select ' || colname || ' from ' || tablename into v_value;
  dbms_output.put_line(v_value);
end;
/
Previous Topic: %rowtype in a cursor
Next Topic: Error message during count
Goto Forum:
  


Current Time: Thu Mar 28 08:20:51 CDT 2024