Managing Data Structures


In Oracle there are a number of types of data structures such as users, privileges, databases, tables, views, index and constraints. Oracle provides Data Definition Language (DDL) commands that are used to manipulate with data structures. Some examples:

In this chapter, we will introduce some useful DDL commands organized in the following sections:

Note that in general a DDL command executes and automatically commits. There is no way to reverse the changes of DDL command using ROLLBACK.