View in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation
View is a database object which provides authority level of security.
View created from tables those tables are called as base tables.
Generally data security point of view dba creating view from the table and then those views given to number of users. generally view does not stores data so view also called as virtual table or window of a table. generally views are created from base tables.
View types:
1) Simple view
2) Complex view or Join view
Simple view is a view which is created from only one base table whereas Complex view is created from multiple base tables.
Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.
https://www.youtube.com/a4uofficial
0 Comments