Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9710 Views
- IBM, I also Faced
- E-Mail Answers
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 |
How to find primary key of a table in db2?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
How does cobol compile db2 program?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How to define the data items to receive the fetch items for the SQL?
What are the abend codes occour in ur latest PROJECT in DB2
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
How does a cursor work?
What is the picture clause of null indicator variable?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
COBOL 
