Quick Search:
 
 The Oracle PL/SQL ROWIDTONCHAR Function      [Return To Index] Jump to:  

Term: ROWIDTONCHAR

Definition:
In Oracle PL/SQL, the ROWIDTONCHAR function is used to convert a ROWID to its equivalent NVARCHAR2 value.

Example Syntax:

ROWIDTONCHAR(n)


In the syntax example above, "n" is of the ROWID type.

Example Usage:

The SQL query below converts a ROWID column to its NVARCHAR equivalent.

SQL> SELECT ROWIDTONCHAR(ROWID) FROM T_ROW;

ROWIDTONCHAR(ROWID)
------------------
AAAIYxAABAAAMiSAAA
AAAIYxAABAAAMiSAAB



Related Links:

Related Code Snippets:
  • ROWIDTONCHAR - ROWIDTONCHAR converts a rowid value to NVARCHAR2 datatype. The result of this conv...
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org