The ROWID function casts a character string to a row ID.
If the actual length of string-expression is less than 40, the result is not padded. If the actual length of string-expression is greater than 40, the result is truncated. If non-blank characters are truncated, a warning is returned.
The length attribute of the result is 40. The actual length of the result is the length of string-expression.
The result of the function is a row ID. If the argument can be null, the result can be null; if the argument is null, the result is the null value.
Syntax alternatives: The CAST specification should be used for maximal portability. For more information, see CAST specification.
SELECT EMPNO FROM EMPLOYEE WHERE EMP_ROWID = ROWID(X'F0DFD230E3C0D80D81C201AA0A280100000000000203')
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.