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

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