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
Explain about mirror activator disk mirroring?
How to access db2 tables in mainframe?
When do you specify the isolation level?
What is meant by union and union all?
What os does db2 run on?
What is the information associated with sysibm.syslinks table?
What is reorg and runstats in db2?
What is node in db2?
What is db2 bind?
What does db2 stand for?
what is the responsibility of the construction superintendent
What is buffer pool in the db2 database?
Explain package in db2 and its advantages?
What is the purpose of rollback and commit?
What is the difference between oracle and db2?