Can someone suggest a change to the code below or an alternative method? I want to be able to execute an insert statement , selecting from a table whose name is variable.
many thanks
declare
l_table varchar(50) := 'PRICE SOURCE';
begin
execute immediate 'INSERT INTO DVD.TMP_DVD_PRICE select * from :1'
using l_table;
commit;
end;