Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9694 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 |
What does db2 stand for?
How can you compare table column after update and before update?
how can i pull up a query which was previously stored in qmf
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
How to select the duplicate rows from a table?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what is dynamic cursor?gives syntax for this?
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
How does the processing of a correlated subquery differ from a non correlated subquery?
Define data page.
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
COBOL 
