CodesJava

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

Please follow and like us:
Posted in SQL   


Copyright © 2019 CodesJava DMCA.com Protection Status SiteMap Reference: Java Wiki