CHARTOROWID

CHARTOROWID in SQL is a function used to convert a string value into a ROWID value. It is primarily used in Oracle databases. This function returns a ROWID value that represents the unique key of a row in a database, aiding in precise identification and manipulation of data rows.

Example

SELECT CHARTOROWID ('00007FFF.0000.0001') AS Example
FROM dual;

Output

EXAMPLE
-------------------
00007FFF.0000.0001

Explanation

This example shows the use of the CHARTOROWID function. It converts a character string that represents a ROWID to a ROWID value. The input ‘00007FFF.0000.0001’ is a valid ROWID in hexadecimal format. The function is selecting this ROWID from the dual table which is a single-row, single-column table present by default in Oracle and other database installations. The result is the ROWID ‘00007FFF.0000.0001’, confirming that the CHARTOROWID function has correctly converted the string to a ROWID.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.