The CHARTOROWID function in Oracle SQL / PLSQL is used to convert the CHAR, VARCHAR2, NCHAR or NVARCHAR2 data-type into ROWID type. Syntax for using the CHARTOROWID function Oracle SQL / PLSQL is: SELECT CHAROROWID (value) FROM table_name; value is the value to be converted to ROWID The format of ROWID is BBBBBBB.RRRR.FFFFF Here, BBBBBBB […]