O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required