The ROWIDTOCHAR function in Oracle SQL / PLSQL is used to cionvert the ROWID to VARCHAR2 datatype, the result is always 18 characters long. Syntax for using the ROWIDTOCHAR function Oracle SQL / PLSQL is; SELECT ROWIDTOCHAR (ROWID) FROM table_name; Example: Using ROWIDTOCHAR function Suppose we have a table named ‘employee’ as shown below: Employee_ID […]