what is the command i.e similar to merge command(9i) in oracle 8i ????????
-
-
before the merge command came to be it was look in the table for your row (select statement), if it existed then update the row, if not then insert it.Originally posted by jisuprusty
It was 3 statements, 3 to parse, 3 to execute and so they came up with the merge statement as 1 statement to parse and execute... its more efficient. -
Merge is available from version 9 onwards.
You need to do that manually in prior versions.Comment
Comment