Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 17 of 177
chartorowid::=
CHARTOROWID
converts a value from CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
datatype to ROWID
datatype.
Note: This function does not support |
The following example converts a character rowid representation to a rowid. (The function will return a different rowid on different databases).
SELECT last_name FROM employees WHERE ROWID = CHARTOROWID('AAAFd1AAFAAAABSAA/'); LAST_NAME ------------------------- Greene
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|