sql11g_13 (1)

sql11g_13 (1) - Oracle 11 g SQL Chapter 13 Views Objectives...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Oracle 11 g : SQL Chapter 13 Views Objectives Create a view by using CREATE VIEW command or the CREATE OR REPLACE VIEW command Employ the FORCE and NOFORCE options State the purpose of the WITH CHECK OPTION constraint Explain the effect of the WITH READ ONLY option Update a record in a simple view Re-create a view Explain the implication of an expression in a view for DML operations Oracle 11g: SQL 2 Objectives (continued) Update a record in a complex view Identify problems associated with adding records to a complex view Identify the key-preserved table underlying a complex view Drop a view Explain inline views and the use of ROWNUM to perform a “TOP-N” analysis Create a materialized view to replicate data Oracle 11g: SQL 3 Views Permanent objects that store no data Stores a query for re-use Two purposes – Reduce complex query requirements Commonly joined tables Routine calculations – Restrict users’ access to sensitive data Oracle 11g: SQL 4 Types of Views Oracle 11g: SQL 5 Creating a View...
View Full Document

{[ snackBarMessage ]}

Page1 / 23

sql11g_13 (1) - Oracle 11 g SQL Chapter 13 Views Objectives...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online