The ROWIDTONCHAR function in Oracle SQL / PLSQL is used to cionvert the ROWID to NVARCHAR2 data type, the result is always in National Character Set and 18 characters long. Syntax for using the ROWIDTONCHAR function Oracle SQL / PLSQL is; SELECT ROWIDTONCHAR (ROWID) FROM table_name; Example: Using ROWIDTONCHAR function Suppose we have a table […]