Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL ROWIDTONCHAR Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 91 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?