Oracle SQL Recipes: A Problem-Solution Approach

Chapter 18. Object Management

This chapter focuses on SQL techniques used to manage database objects, including object types such as tables, indexes, views, and synonyms. The SQL statements you use to create and modify objects are often referred to as data definition language (DDL) statements. Managing DDL is part of a database administrator's daily job. DBAs frequently generate and modify DDL scripts to build development, test, staging, and production databases. For these reasons a DBA needs to be particularly deft at writing DDL.

Some will argue that only a database administrator should maintain and manage DDL and that developers should keep their hands out of schema management. However, the reality is that developers often find themselves in ...