Chapter 12. Views, Indexes, Sequences, and Synonyms (DDL)

Terms You Need to Understand

  • ✓ View

  • ✓ Index

  • ✓ Sequence

  • ✓ Public synonym

  • ✓ Private synonym

  • ✓ Virtual column

Concepts You Need to Master

  • ✓ Updatable views

  • ✓ Constraint views

  • ✓ Updating join subquery views

  • ✓ Changing table data using updatable views

  • ✓ The WITH CHECK OPTION for updatable views

  • ✓ Changing views must account for all required (NOT NULL) columns in the underlying table (unless NOT NULL columns have DEFAULT settings)

  • ✓ What virtual columns are and what causes them to be created

  • ✓ Creating, altering, and dropping views

  • ✓ Creating, altering, and dropping indexes

  • ✓ Creating, altering, and dropping sequences

  • ✓ Creating and dropping synonyms

This chapter describes views, indexes, sequences, and synonyms. ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.