So far this book has used pre-built objects but now it’s time to start making our own. This book assumes you are familiar with basic Data Definition Language commands like CREATE TABLE. This chapter describes advanced features of Oracle schema objects and the advanced DDL commands to create and maintain them.
This chapter does not create an exhaustive list of features and expect you to memorize the syntax. Instead, the goal is to introduce a wide variety of features. Exposure to these new features and commands will give you ideas for your current and future projects. ...