Oracle Database/Views

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

Creating simple and complex views[edit]

Retrieving data from views[edit]

Creating, maintaining, and using sequences[edit]

Creating and maintaining indexes[edit]

Creating private and public synonyms[edit]

Dictionary views[edit]

Explaining the data dictionary[edit]

Finding table information[edit]

Reporting on column information[edit]

Viewing constraint information[edit]

Finding view information[edit]

Verifying sequence information[edit]

Understanding synonyms[edit]

Adding comments[edit]