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!

Difference between ROWID and ROWSTAMP

Nagaraja AkkivalliOct 26 2013 — edited Oct 26 2013

Hi All,

Can you please explain me the difference between ROWID and ROWSTAMP in oracle ?

I am implementing incremental/delta load for one of the table. It requires a PrimaryKey and ChangeDate(date identifies modified records) column. We have Primary key but for change date we need to use ROWID/ROWSTAMP column.

1. Which column identifies modified records? Is that ROWID or ROWSTAMP ?

2. Is the ROWID column holds integer value ?

3. Is the ROWSTAMP column holds integer/timestamp value ?

As we are accessing oracle table from one of the tool, we are not privileged to use ROWID columns. Please show some light on this.

Thanks for your help in advance.

Thanks and Regards

Nagaraja Akkivalli.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2013

Added on Oct 26 2013

#database

3 comments

2,526 views