Skip to Main Content

Oracle Database Express Edition (XE)

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!

May be a BUG: DELETE with same predicate as SELECT fails

Gurpreet S. GillMar 10 2007 — edited Oct 10 2008
Hi,
I select a concatenation of rowid and ora_rowscn as
SQL>SELECT ROWID||ORA_ROWSCN FROM TT;

OUTPUT:
ROWID||ORA_ROWSCN
-----------------------------
AAADkOAAEAAAADWAAA1006305


Now when i select as 

SQL> SELECT * FROM TT
  2  WHERE
  3  ROWID = 'AAADkOAAEAAAADWAAA'
  4  AND
  5  ORA_ROWSCN = 1006305;

OUTPUT:
ONE
----------
A

but when i try to delete as

SQL> DELETE FROM TT
  2  WHERE
  3  ROWID = 'AAADkOAAEAAAADWAAA'
  4  AND
  5  ORA_ROWSCN = 1006305;

OUTPUT:
0 rows deleted.


Again, when i try Update as

SQL> UPDATE  TT SET ONE='PPP'
  2  WHERE
  3  ROWID = 'AAADkOAAEAAAADWAAA'
  4  AND
  5  ORA_ROWSCN = 1006305;

OUTPUT:
1 rows updated
Why this is so?

If it is BUG then, How can i raise a it for "Oracle Database 10g Express Edition" ?


Kind Regards,
Thanks.

Gurpreet S. Gill
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 7 2008
Added on Mar 10 2007
21 comments
982 views