oracle 如何用存储过程创建视图

Question

举个例子最直接 最好

Answer 1

-- 创建测试 用表
create table t1(id number,txt varchar2(20);
-- 存储过程，参数为stmt
CREATE OR REPLACE PROCEDURE t1_makeview_prc (stmt VARCHAR2)
IS
-- stmt VARCHAR2(200);
BEGIN
-- stmt := 'CREATE OR REPLACE VIEW t1_v AS SELECT * FROM t1';
EXECUTE IMMEDIATE stmt;
END t1_makeview_prc;
-- 文件->开始->测试窗口
begin
t1_makeview_prc('CREATE OR REPLACE VIEW t1_v AS SELECT * FROM t1');
end;
-- 执行创建的存储过程测试，t1为已经创建的表

Answer 2

用动态sql：

execute immediate "create view v_a as select .... from ... ";