Oracle Database/Views

From Wikibooks, open books for an open world
Jump to navigation Jump to search

Creating simple and complex views[edit | edit source]

Retrieving data from views[edit | edit source]

Creating, maintaining, and using sequences[edit | edit source]

Creating and maintaining indexes[edit | edit source]

Creating private and public synonyms[edit | edit source]

Dictionary views[edit | edit source]

Explaining the data dictionary[edit | edit source]

Finding table information[edit | edit source]

Reporting on column information[edit | edit source]

Viewing constraint information[edit | edit source]

Finding view information[edit | edit source]

Verifying sequence information[edit | edit source]

Understanding synonyms[edit | edit source]

Adding comments[edit | edit source]