Re: rowid question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 07 Sep 1999 09:29:52 -0400
Message-ID: <9RLVN8dZ9JLTzLz5M1cbYLRb9CzQ@4ax.com>

A copy of this was sent to "Lisa" <lewis_at_mars-systems.com> (if that email address didn't require changing) On Tue, 7 Sep 1999 09:25:06 -0400, you wrote:

>Does anybody know what special characters can compose a rowid? I know that
>it can contain a '+' sign. Can a rowid contain any other special
>characters?
>
>Thanks for your time!
>Lisa
>P.S. please respond via e-mail if possible
>

In 7.3 and before rowids had:

0-9
A-F
.

in them. In 8.0 and up, they are base64 encoded numbers and that encoding scheme uses:

A-Z
a-z
0-9

+
/

(so a slash is in there as well as the +)

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Sep 07 1999 - 08:29:52 CDT