CHAPTER 11
SQL Data Definition Statements
The main SQL definition statements in an Oracle 10G environment are shown in Figure 11-1. These statements relate to the six basic types of database objects in Oracle — tables, indexes, views, constraints, synonyms, and sequences. Other more advanced types of database objects include databases, table-spaces, data-files, users, user profiles, functions, and procedures.
Figure 11-1. Commonly Used SQL Definition Statements
This chapter will focus on tables, synonyms, sequences and indexes; a discussion of ...
Get Database Systems 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.
