create or replace procedure p_temp_t(in_id in number) as
begin
execute immediate 'CREATE GLOBAL TEMPORARY TABLE t_temp ON COMMIT PRESERVE ROWS as (
select
a.id,
b.name
from a
left join b
on a.id = b.id
where a.id = '|| in_id ||');'
;
end;

原语句：
execute immediate 'CREATE GLOBAL TEMPORARY TABLE table_name ON COMMIT PRESERVE ROWS as (
select
a.id,
b.name
from a
left join b
on a.id = b.id
where a.id = in_id(参数)
);'

修改：
execute immediate 'CREATE GLOBAL TEMPORARY TABLE table_name ON COMMIT PRESERVE ROWS as (
select
a.id,
b.name
from a
left join b
on a.id = b.id
where a.id = ?
);' using (传入的参数);

下面为一个测试例子：