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 |
Explain about mirror activator disk mirroring?
What is the use of db2 optimizer?
wht steps we need will coding cobol and db2 pgm ?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
how do we solve soc 7 and soc4 ?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Which command is used to connect to a database in DB2 ? Give the Syntax.
When would you prefer to use VARCHAR?
What are the advantages of using a PACKAGE?
What is reorg in database?
What are the 4 environments which can access DB2 ?
How can you do the explain of a dynamic sql statement?