Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: GUID to CHAR conversion function?

Re: GUID to CHAR conversion function?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 17 Mar 2006 13:11:13 -0800
Message-ID: <1142629872.998622.200330@j52g2000cwj.googlegroups.com>


Troy, take a look at the $ORACLE_HOME/rdbms/admin/utlraw.sql script which creates the utl_raw package. The package contains procedures to convert varchar2 to raw and raw to varchar2. You would need to write you own function to handle the formatting of individual areas of your key.

Oracle has a function named sys_guid that is intended to generate global unique identifiers that you may want to look at. See SQL manual.

HTH -- Mark D Powell -- Received on Fri Mar 17 2006 - 15:11:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US