Data Manipulation Language (DML) commands
by satheesh[ Edit ] 2010-01-28 19:59:30
Data Manipulation Language (DML) statements are used for managing data within schema objects.
Some examples:
* SELECT - retrieve data from the a database
* INSERT - insert data into a table
* UPDATE - updates existing data within a table
* DELETE - deletes all records from a table, the space for the records remain
* MERGE - UPSERT operation (insert or update)
* CALL - call a PL/SQL or Java subprogram
* EXPLAIN PLAN - explain access path to data
* LOCK TABLE - control concurrency