Question

Explain the various DML commands with examples.

Answer 1

Some commands of DML are:

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

LOCK TABLE – control concurrency

Answer 2

Hey !$<b>$

DML Commands  :

1) INSERT INTO

2) DELETE

3) UPDATE