Movatterモバイル変換

Syntax

Description of the illustration rowidtonchar.eps

Purpose

ROWIDTONCHAR converts a rowid value toNVARCHAR2 data type. The result of this conversion is always in the national character set and is 18 characters long.

See Also:

Appendix C inOracle Database Globalization Support Guide for the collation derivation rules, which define the collation assigned to the character return value ofROWIDTONCHAR

Examples

The following example converts a rowid value to anNVARCHAR2 string:

SELECT LENGTHB( ROWIDTONCHAR(ROWID) ) Length, ROWIDTONCHAR(ROWID)    FROM employees   ORDER BY length;     LENGTH ROWIDTONCHAR(ROWID---------- ------------------        36 AAAL52AAFAAAABSABD        36 AAAL52AAFAAAABSABV. . .