insert into t_Table
(id,name,address,phone,TableName)
select id,name,address,phone,'t_Customer'
from t_Customer
(id,name,address,phone,TableName)
select id,name,address,phone,'t_Customer'
from t_Customer
调试欢乐多
要写动态SQL怎么写呢
STRSQL VARCHAR(100);
V_TABLENAME VARCHAR(10);
STRSQL:='insert into t_Table(id,name,address,phone,TABLENAME)';
STRSQL:=STRSQL || 'select id,name,address,phone,' || V_TABLENAME;
STRSQL:=STRSQL || 'FROM' || V_TABLENAME;
EXECUTE IMMEDIATE STRSQL;