Executing Data Manipulation Language (DML) statements

Data manipulation language (DML) statements can change data in the database tables. For example, DML statements are used to:

· UPDATE column values in existing rows

· DELETE rows from a table

· INSERT new rows into a table

The OraDatabase interface in OO4O provides two methods, ExecuteSQL and CreateSQL, for executing DML statements. The discussion below will cover how these methods can be used to execute various types of DML statements.