Interested to Buy Any Domain ? << Click Here >> for more details...
What does DML stand for and what are some examples of it?
- 3 Answers
- 9818 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What are the different types of base tables?
Who uses db2?
List out the data types available.
Highlight all the advantages that are attached to a package.
What is the role of the data page in the db2 database?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a db2 package?
How to test SQL -911 error while developing COB-DB2 program
What is database reorganization?
What are the full forms of spufi and dclgen and why are they used?
What is cursor stability in db2?
What are concurrency issues?
What is dbrm?
What is drop table?
