Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tablename variable. How To?

Tablename variable. How To?

From: Kenneth Herskedal <kenneth.herskedal_at_NOSPAMtrafsys.no>
Date: Tue, 20 Jul 1999 12:27:49 GMT
Message-ID: <9XZk3.3097$cc.188014080@news.telia.no>


I have a table name stored in a CHAR(15). I want to performe a select statement on this table.

How can I use this variable in the SQL?

tt char(15)
..
fetch stat into tt;
select * from tt; -- Not working!!

Thanks in advance. Received on Tue Jul 20 1999 - 07:27:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US