What does DML stand for and what are some examples of it?

Answer Posted / srinivasa yadav

DML STANDS FOR DATA MANIPULATION LANGUAGE
THE COMMANDS IN DML ARE SELECT, INSERT, DELETE, UPDATE
EX:-SELECT
1) SELECT * FROM TABLENAME;
IT WILL RETRIVE ALL THE COLUMNS.
2) SELECT EMP_ID,EMP_HLDR_NAME,EMP_AMT FROM TABLENAME;
IT WILL RETRIVE ONLY PARTICULAR ROWS.
INSERT : - IT IS USED TO INSERT THE VALUES.
DELETE : - IT IS USED TO DELETE THE ROW.
UPDATE : - IT IS USED TO UPDATE THE ROW.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

796


How to run db2 command in windows?

876


What is the difference between using bind () and rebind () methods of naming class?

1069


Why do chiropractors use drop table?

876


How to take backup of table in db2?

809


What type of database is db2?

710


How can you find out the # of rows updated after an update statement?

855


What is the use of value function?

838


What is dclgen in db2?

879


What is a db2 collection?

797


Explain package in db2 and its advantages?

833


What are concurrency issues?

804


What does sqlcabc has?

795


What is image copy in db2?

752


Highlight all the advantages that are attached to a package.

874