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

What is db2 optimizer?

769


List out the three types of page locks that can be held.

685


What is a db2 table?

593


What do you mean by storage group (stogroup)?

580


Discuss about db2 bind?

667






Define sqlca.

647


What is copy pending status in db2?

634


What is meant by dclgen?

618


What is the physical storage length of the data types date, time, and timestamp?

604


What are db2 objects?

635


What kind of database is db2?

569


What is the difference between spufi and qmf?

635


What is netezza database?

570


What is package in cobol db2?

698


What is ibm db2 connect?

570