Sequences

Thumbnail image for Replace Duplicates in ID Column with Unique Values

Replace Duplicates in ID Column with Unique Values

A solution to the requirement of replacing only the duplicate IDs with unique values in a database table, and letting everything else stay untouched.

Read the Full Article →
Thumbnail image for MERGE: Insert New Rows, Update Existing Rows in One Shot

MERGE: Insert New Rows, Update Existing Rows in One Shot

MERGE in Oracle combines the power of INSERT and UPDATE into one power-packed statement

Read the Full Article →

How to Reset a Sequence in Oracle

Oracle does not a have ready-made command to restart a sequence. But with this simple workaround, you can reset a sequence in Oracle.

Read the Full Article →
Thumbnail image for RETURNING the value of an auto-increment column

RETURNING the value of an auto-increment column

How to use the RETURNING clause to identify the value assigned to an auto-increment column during a particular INSERT. You might use this information for further transactions in related tables or for auditing.

Read the Full Article →
Thumbnail image for Auto-Increment Columns: FAQ

Auto-Increment Columns: FAQ

Auto-increment columns indatabase tables help to maintain uniqueness and track recency. Answers to frequently asked questions about auto-increment columns.

Read the Full Article →