Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© Jon Heller 2019

Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_9

9. Improve the Database with Advanced Oracle Schema Objects

Jon Heller¹ 

(1)

Clive, IA, USA

 

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