What does DML stand for and what are some examples of it?
Answers were Sorted based on User's Feedback
Answer / deepak dada
data manipulation language eg select insert update delete
|Is This Answer Correct ?||4 Yes||0 No|
Answer / srinivasa yadav
DML STANDS FOR DATA MANIPULATION LANGUAGE
THE COMMANDS IN DML ARE SELECT, INSERT, DELETE, UPDATE
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 ?||1 Yes||0 No|
What is the difference between Where and Having Clause
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
When Can you be sure that a query will return only one row?
How can you classify the locks in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What are the two types of logging in the db2 database? Explain them.
What is an asychronous write?
How to access db2 tables in mainframe?
What is bufferpool in db2?
how to unload different table data into different gdg files/ vsam files.
What is db2 command?
What is db2 purescale?