用动态SQL语句
--------------------------------------------------
CREATE OR REPLACE PROCEDURE mcdb.PGM IS
BEGIN
execute immediate 'CREATE OR REPLACE VIEW A_VIEW AS ' ||
'SELECT field1,field2,field3 FROM A_TABLE';
END PGM;
--------------------------------------------------
CREATE OR REPLACE PROCEDURE mcdb.PGM IS
BEGIN
execute immediate 'CREATE OR REPLACE VIEW A_VIEW AS ' ||
'SELECT field1,field2,field3 FROM A_TABLE';
END PGM;
例如
begin
cmdb.PGM;
end;
mcdb.PGM;
end;编译可以了,但还是看不到生成的视图,为什么阿?