From the course: Oracle Database 19c: Advanced SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

DDL command types

DDL command types - Oracle Database Tutorial

From the course: Oracle Database 19c: Advanced SQL

Start my 1-month free trial

DDL command types

“

- [Informant] Oracle's data definition language, is a subset of oracle SQL that lets you create, drop and modify objects in your database. Let's start with what types of objects you can manipulate with data definition language, DDL and what kinds of operations you can perform on them. You could call every command in oracle, a SQL statement. But it's important to know the differences. Query statements are what almost everyone who knows something about databases knows how to select rows and columns from database tables. Data definition language allows you to create, drop and modify database objects. Data manipulation language, DML, is exactly what it says. Modifying, adding or deleting rows in a table using statements like insert, update, delete and merge. Transaction control works on top of the DML infrastructure, allowing you to commit or roll back an operation. Session and system control change your environment, such as modifying a database parameter. You can also embed any of your…

Contents