当前位置：网站首页>Oracle view related

Oracle view related

2022-04-23 13:40:00 【Wangcai 2】

Create a read-only view ( The non read-only view only needs to be removed with read only that will do )：

create view students_v
as 
select sno,sname from students
with read only

Delete view ：DROP VIEW VIEW_NAME Statement delete view .

Deleting the definition of a view does not affect the data in the base table .

Only the view owner and have DROP VIEW Users with permissions can delete views .

After the view is deleted , Other views or apps based on the deleted view will be invalid .

Modified base table data , When querying the view , The displayed data is also synchronously modified .

版权声明
本文为[Wangcai 2]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230604301336.html