In Oracle/PLSQL, the chartorowid function converts a char, varchar2, nchar, or nvarchar2 to a rowid.
Syntax
The syntax for the chartorowid function is:
chartorowid( value1 )
value1 is the value to convert to a rowid.
The format of the rowid is:
BBBBBBB.RRRR.FFFFF
where:
BBBBBBB is the block in the database file;
RRRR is the row in the block;
FFFFF is the database file.
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
select * from suppliers
where rowid = chartorowid('AAABoqAADAAAAwPAAA');
This would return a unique row from the suppliers table.