Data Definition Language
Statements that create, modify, or change schema objects are termed as Data Definition Language (DDL) statements. The CREATE, ALTER
, and DROP
statements are examples of DDL statements. We create a new schema object using the CREATE
statement, modify existing schema objects using the ALTER
statement, and remove the schema object from the schema using the DROP
statement. We will explore more on DDL statements in the following topics.
The DDL statements can be executed either using SQL*Plus command line or using SQL Developer.