Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> rowid can contain slashes???

rowid can contain slashes???

From: Alexander Zimmer <asdf_at_webpim.at>
Date: Mon, 19 Aug 2002 15:44:02 +0200
Message-ID: <MPG.17cb14796d25e72b989686@news.cis.dfn.de>


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:44:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US