Data Manipulation Language (DML) commands

by satheesh 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

Tagged in:

893
like
0
dislike
0
mail
flag

You must LOGIN to add comments