Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 80 of 121
ROWIDTOCHAR
converts a rowid value to VARCHAR2
datatype. The result of this conversion is always 18 characters long.
SELECT ROWID FROM offices WHERE ROWIDTOCHAR(ROWID) LIKE '%Br1AAB%'; ROWID ------------------ AAAAZ6AABAAABr1AAB
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|