Home » SQL & PL/SQL » SQL & PL/SQL » Using Variables/Parameters In FROM Clause
Using Variables/Parameters In FROM Clause [message #38279] Sun, 07 April 2002 14:50 Go to next message
Groves
Messages: 1
Registered: April 2002
Junior Member
How to accomplish this? I have field and table names in a stored procedure that are a combination of variables and passed parameters. I need to perform a query based on these variables. Here's my last attempt (unsuccessful)
  DECLARE @TableNm VarChar(25)
  SET @TableNm = 'mytable'
  SELECT * FROM @TableNm

Anyone?
Re: Using Variables/Parameters In FROM Clause [message #38281 is a reply to message #38279] Sun, 07 April 2002 18:06 Go to previous message
oraboy
Messages: 97
Registered: October 2001
Member
create or replace procedure(tname varchar2)
qry varchar2(1000) := 'Select * from '||tname;
res ref cursor; --refer syntax to declare this as ref cursor or declare this is Pl/SQL record
begin
Execute immediate qry into res;
....
end;
Previous Topic: bulk loading
Next Topic: Insert query
Goto Forum:
  


Current Time: Tue Mar 19 01:44:18 CDT 2024