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 |
DML stands for Data Manipulation Language.This langage
enables the users to make manipulation operations on the
data present in the database.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
cursor with hold explain ?
What is host variable?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Where besides the DB2 catalog is database object information stored by DB2?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
What is sqlca?
What is db2 look?
How can you classify the locks in db2?
how to check the table is empty or not?
How to restart a DB2 program?
What is cascading rollback?
What are the four lockable units for DB2?