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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA_ROWSCN multiple tables

499912Mar 20 2006 — edited Mar 22 2006

Hi, I am new to Oracle and I'm having some trouble using/understanding the ORA_ROWSCN pseudocolumn.

In my application I am implementing SQL updates using RowID and ORA_ROWSCN. This seems to work fine when i am reading/updating a single table.

E.g. Reads -
SELECT EMPLOYEE_ID, EMPLOYEE_NAME, ROWID, ORA_ROWSCN FROM EMPLOYEES

Updates - UPDATE EMPLOYEES SET EMPLOYEE_NAME = :Param0 WHERE RowID = :ParamRowID AND ORA_ROWSCN = :ParamROWSCN

However there are instances where i need to join multiple tables to create an appropriate recordset. In this instance I do not appear to be able to select the ORA_ROWSCN's for each table in the SELECT JOIN. Why is this the case?

Any advice would be much appreciated.

Matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2006

Added on Mar 20 2006

7 comments

733 views