© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
J. HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-8867-2_9

9. Improve the Database with Advanced Schema Objects

Jon Heller1  
(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 interesting features. Exposure to these ...

Get Pro Oracle SQL Development: Best Practices for Writing Advanced Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.