Concat variable to form Table name inside Select statement

[soelistyani]

Are you looking for this?

SET @a = 'table';
SET @x := CONCAT('SELECT * FROM ', CONCAT(@a, '_', 'name'));
Prepare stmt FROM @x;
Execute stmt;

This is equal to

SELECT * FROM table_name;

i need help,
how to Concat variable to form Table name inside insert statement in PL/SQL in oracle 7.3 ?

thank you..

[mwasif]

Hi soelistyani,

Welcome to TSDN!!!

I am moving the question to Oracle Forum.

[debasisdas]

try like the following sample code snippet.

declare
t_name carchar2(30) :=&t_name;
str_ins varchar2(200);
begin
str_ins:='insert into' || t_name || 'values  (...........,........,..........);
 
execute immediate str_ins ;
end;
 
 

[vallis]

Hello
I m also having requiremnet of same kind.
I would like to know how to concat a variable to a table in pl/sql
as i need to insert data from the concated table to a custom table
please help

thanks

[debasisdas]

Hello
I m also having requiremnet of same kind.
I would like to know how to concat a variable to a table in pl/sql
as i need to insert data from the concated table to a custom table
please help

thanks

kindly post the code that you are working on for reference of our experts.