1、不太明
2、
create trigger a_tri
before insert on a
for each row
declare
str varchar2(60);
begin
str:='create table b (...)';
execute immediate str;
end;
/
2、
create trigger a_tri
before insert on a
for each row
declare
str varchar2(60);
begin
str:='create table b (...)';
execute immediate str;
end;
/
-->如果你指的是在不执行select语句的前提下了解它的执行路径,可以用sqlplus中
的set autotrace traceonly
截取'select'与'from'之间的部分,不知道我理解的对不对
如果是select * from tbname,就要到数据字典中查这个表的每个字段名了
declare
pragma autonomous_transaction;
v varchar2(50);
begin
v:='create table a(n number)';
execute immediate v;
end;
/