RE: Doubt related to ROWID
From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Wed, 10 Jul 2013 22:48:53 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CDECA36_at_ICATMAIL1.ICAT.com>
From here: http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns008.htm (10g but probably valid in later versions, ymmv)
Date: Wed, 10 Jul 2013 22:48:53 +0000
Message-ID: <D18D6513433DF04394041EA42B53E91C9CDECA36_at_ICATMAIL1.ICAT.com>
From here: http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns008.htm (10g but probably valid in later versions, ymmv)
This: Usually, a rowid value uniquely identifies a row in the database. However, rows in different tables that are stored together in the same cluster can have the same rowid.
hth,
-joe
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eriovaldo Andrietta
Sent: Wednesday, July 10, 2013 4:40 PM
To: ORACLE-L
Subject: Doubt related to ROWID
Hi friends,
I would like to know if ROWID is a unique identifier for :
(1) --> a line in the table
(2) --> a line in the database
Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-l Confidentiality Note: This message contains information that may be confidential and/or privileged. If you are not the intended recipient, you should not use, copy, disclose, distribute or take any action based on this message. If you have received this message in error, please advise the sender immediately by reply email and delete this message. Although ICAT Managers, LLC, Underwriters at Lloyd's, Syndicate 4242, scans e-mail and attachments for viruses, it does not guarantee that either are virus-free and accepts no liability for any damage sustained as a result of viruses. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 11 2013 - 00:48:53 CEST