SQL Tutorial : VIEW
Let's learn about next topic: VIEW
VIEWS:
*******
- VIRTUAL TABLES.USED TO RESTRICT THE ACCESS
SIMPLE VIEW:
1. ONE TABLE
2. DML IS POSSIBLE
COMPLEX VIEWS:
1. MORE THAN ONE TABLE
2. PSEUDO COLUMNS (ROWNUM,ROWID)
3. GROUP FUNCTIONS AND GROUP BY
4. DISTINCT
5. COMPLEX EXPRESSIONS
6. NOT NULL COLUMNS IN THE TABLE IS NOT A PART OF VIEW
No comments:
Post a Comment