Oracle视图更新

Oracle支持针针对视图的更新，真实太方便了

Create or Replace View v_td_department As
Select department_id As dept_Id,item_note as note From td_department


update v_td_department set note='0' where dept_Id='01'

 

posted @ 2021-12-14 14:37  notis  阅读(464)  评论(0)  编辑  收藏  举报