Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS THE USE AND DIFF B/W INSERT, UPDATE AND MODIFY
WHILE UPDATING THE DATABASE TABLES?
- 3 Answers
- 8987 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
What is the use of abap data dictionary? : abap data dictionary
How would you set the formatting options statically and dynamically within a report?
What is an update task?
How can we handle table control in bdc? : abap bdc
What is the collect statement?
Explain the difference between function group and function module?
How many types of tables exists and what are they in data dictionary? : abap data dictionary
What are the major steps will you use for tuning?
What is the difference between the exits created in M.M and S&D?
What is an update type with reference to a match code id? : abap data dictionary
What is the difference between a structure and an append structure?
What are the page windows?
Event handling in oops
after creating lock object if does n't access record by second user what should we do?
What functions does a data dictionary perform ?
