SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Which approach to choose to insert only new records when there any change on any of the columns?

Rajiv TApr 17 2024 — edited Apr 18 2024

Need to insert into table using input parmater but need to avoid Duplicate entries.It has 30 parmaters. ANd this insertion takes place multiple times per day. Which approach is the best to use? Is it merge or any other way to insert only new record in Oracle?

Added on Apr 17 2024

#oracle, #oraclesql, #pl-sql, #sql-developer, #sql-pl-sql, #sql/plsql, #sqlmerge

7 comments

610 views