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

Term: ROWIDTOCHAR

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

Example Syntax:

ROWIDTOCHAR(n)


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

Example Usage

The SQL query below converts a ROWID column to its string equivalent:

SQL> SELECT ROWIDTOCHAR(ROWID) FROM T_ROW;

ROWIDTOCHAR(ROWID)
------------------
AAAIYxAABAAAMiSAAA
AAAIYxAABAAAMiSAAB



Related Links:

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