WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
- 3 Answers
- 7132 Views
- Sony, I also Faced
- E-Mail Answers
Answer Posted / sudhakar1207
INSERT IS USE TO INSERT THE RECORDS INTO A DB TABLE.
UPDATE IS USED TO CHANGE DATA OF THE EXISTING RECORDS IN THE DB TABLE.
MODIFY IS ALSO USED TO CHANGE DATA.
BUT THE MAIN DIFF B/W UPDATE AND MODIFY IS
UPDATE ONLY CHANGE THE EXISTING RECORD. IF THE RECORD DOES NOT EXIST IT WILL GIVE A SHORT DUMP.
MODIFY CHANGE THE DATA IF THE RECORD EXISTS, OTHERWISE IT WILL INSERT NEW RECORD.
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
Define spool request?
How do I find the output type of a table or a program?
What is the difference between upload and ws_upload ? : abap bdc
What is the difference between refresh and free statements?
What are the aggregate objects in the data dictionary? : abap data dictionary
What is design pattern? Provide example .Why are we using it?
What is the first thing you do after vendor setup is complete?
what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary
What is the different type of projects? : sap abap hr
Explain the different types of view?
Which transaction code can I use to analyze the performance of abap program?
What is the difference between a substructure and an append structure? : abap data dictionary
How do you process errors in call transaction method? : abap bdc
What is difference between dependent and independent data?
when do you need to create an internal table with header line ? and with out a header line?
