Re: rowid can contain slashes???

Hi Alexander,

Relax, it's perfectly normal !!

A rowid indeed is encoded in base 64 which of course requires 64 distinct characters. A - Z , a - z and 0 - 9 covers 62 of them so we are 2 short which are represented by the / and + characters.

So the rowids listed below are quite valid and no where near as weird as Ozzy Osbourne whom I had the pleasure to watch again tonight ;)

Cheers

Richard

Alexander Zimmer wrote:
>
> Hi, there!
>
> The following select:
>
> select rowidtochar(rowid) from MY_TABLE1
>
> yields the following result:
>
> AAAHH/AADAAAC9zAAB
> AAAHH/AADAAAC9zAAC
> AAAHH/AADAAAC9zAAD
> ...
>
> As far as I can see, it is the only table with - uhm - weird results in
> the rowid.
>
> Since my program logic is slightly confused (becauses I always assumed
> ROWID as consisting merely of characters and numbers), I would like to
> know:
>
> Does anybody know which chars the RowID can consist of (apparently it's
> NOT a hex string as stated in Oracle Docu 8.1.6!)? A slash is allowed??
> Is this version specific?
>
> Especially I'm interested in informations regarding 8.1.6 and 8.1.7.
>
> TIA,
> Alex
Received on Mon Aug 19 2002 - 08:54:31 CDT