WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
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
What is a multiple line field? : abap bdc
Concepts of OO ABAP and why we are using it?
What are control tables?
What is page window?
What will you code in start-of-selection & end-of-selecton & why?
What is the function of the transport system and workbench organiser?
What is design pattern? Provide example .Why are we using it?
What are the two ways of producing a list within a transaction?
what is diff between idocs,bdc,rfc and bapi. give real time answer
What is your current client number?
What does an exec sql statement do in abap?
What is the difference between sum and collect?
How to determine the attributes of an internal table?
What are the abap/4 commands that link to a layout set?
Is it possible to bring select option in module pool screens?