Specifying an Oracle Hint at INSERT

Friday Apr 16th 2021 by Octavia Andreea Anghel
Article Image

Learn how to specify an Oracle Hint at INSERT in this quick database tip.

How to Specify an Oracle hint at INSERT (Note: this hint ignores duplicate key errors):

INSERT /*+ ignore_row_on_dupkey_index(foo_table(foo_table_id)) */ into foo_table(...) ...
Mobile Site | Full Site