如何为select和update命令创建视图的存储过程 [英] how to create a stored procedure for views for select and update command

问题描述

你好，

i是oracle的新手，还在学习存储过程....

我想创建一个存储过程，它将生成包含不同表的视图（让我们说只有两张桌子）....



请帮助我......我不知道怎么创建它。

你的帮助将不胜感激..



谢谢

USER

Hello,
i am new in oracle and still learning stored procedures....
I want to create a stored procedure which will generate Views comprise of different tables(lets say for only two tables)....

Please help me... i dont know how to create it.
Your help would be appreciated greatly..

Thank you
USER

推荐答案

请检查以下查询，希望它有所帮助，

Hi,

Please check following query, hope it helps,

CREATE OR REPLACE PROCEDURE procname AS

BEGIN

execute IMMEDIATE 'CREATE OR REPLACE VIEW viewname AS
     SELECT col1,col2
     FROM table1
     UNION ALL
     SELECT col1, col2
     FROM table2;
END;

谢谢，

Hitesh

Thanks,
Hitesh

如果你想要要在SP中创建视图，您需要使用动态SQL。

If you want to create a view within a SP you need to use dynamic SQL.

create procedure Procvewsample
as
exec ('create view testView as select a as Col')

已修复代码块

Code block fixed

这篇关于如何为select和update命令创建视图的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！