Differences Between DML and DDL Processing

 Oracle Database processes DDL differently from DML.

blockchain training courses malaysia

For example, when you create a table, the database does not optimize the CREATE TABLE statement. Instead, Oracle Database parses the DDL statement and carries out the command.

azure training courses malaysia

In contrast to DDL, most DML statements have a query component. In a query, execution of a cursor places the row generated by the query into the result set.

aws training courses malaysia

The database can fetch result set rows either one row at a time or in groups. In the fetch, the database selects rows and, if requested by the query, sorts the rows. Each successive fetch retrieves another row of the result until the last row has been fetched.

angular training courses malaysia

See also

Oracle Database Development Guide to learn about processing DDL, transaction control, and other types of statements