Dynamic tablenames??

[aljubicic]

Hi All,

Is it possible to pass use a variable or constant to pass the table name in a select query??

Such as the following

DECLARE
tablename CHAR(30);

BEGIN

tablename := 'Table'
SELECT * from tablename;

END;


Or is there another way of doing querying tables dynamically??

Any help would be great

Regards
Anthony

 

[sem]

Only with dynamic sql(just an ilustration):

execute immediate 'select * from '||tablename;



Regards, Dima

http://seminihin.narod.ru

 

[nagornyi]

I think lexical parameter can also be used :
select * from &tablename

 

[sem]

Lexical parameters are processed by client applications, thus this solution is not generic (some tools are unaware of & meaning, other use completely different notations).

Regards, Dima

http://seminihin.narod.ru

 

[aljubicic]

Excuse me sem but I didn't quite understand you first comment. So how would I relate it to my example??