Easy learning with example program codes

What are various DML commands in SQL?

1. SELECT – It is used to retrieve the records from the database.
2. INSERT – It is used to create a record.
3. UPDATE – It is used to modify an existing record.
4. DELETE – It is used to delete all records from a table, the space for the records remain.
5. MERGE– It is used to insert or update a record.
6. CALL – call a PL/SQL or Java subprogram.
7. LOCK TABLE – It is used to control concurrency.

Related topics

Posted in SQL   

Copyright © 2018 CodesJava Protection Status SiteMap