What does DML stand for and what are some examples of it?
- 3 Answers
- 8046 Views
- IBM, I also Faced
- E-Mail Answers
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
What do you mean by cursor?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the syntax for FETCH in DB2 ?
Mention data types used in db2 ?
Define db2 and its databases?
i want to maintain uniqueness on pdf without make lf??????????
What is commit in db2?
What is meant by union and union all?
What do you mean by between and in? Is between inclusive of specified range values?
Is db2 a mainframe?
How can we read records for specific member in CL? AND rpg?
Explain about mirror activator disk mirroring?
What are the two types of logging in the db2 database? Explain them.
What is dclgen in db2?
What is dclgen (declaration generator)?
