<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[gentten的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/gentten</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; gentten]]></copyright><item><title><![CDATA[Oracle 视图CURD]]></title><link>https://blog.youkuaiyun.com/gentten/article/details/88530139</link><guid>https://blog.youkuaiyun.com/gentten/article/details/88530139</guid><author>gentten</author><pubDate>Wed, 13 Mar 2019 12:58:47 +0800</pubDate><description><![CDATA[1.创建视图

create view 视图名 as select ...

例如

create view v_test as select t.c_dv_oper_type from T_S_FUN_RIGHTS t where t.c_fun_code='dzqTest'

视图：







基本表：







（oracle 可以不设置主键）

-----------------...]]></description><category></category></item></channel></rss>