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
Before you give the explain statement, what are the prerogatives?
What is bind package and plan in db2?
How do I delete a table in database?
What is the role of schema in the db2 database?
Comment whether the cursor is closed during commit or not.
How to find the number of rows in a db2 table?
What is host variable?
Name the lockable units in DB2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is bufferpool in db2?
What is db2 plan table?
Explain about mirror activator disk mirroring?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
On which levels locks can be applied?
What does db2 blu stand for?