Russ - What do you have in mind? Oracle stores numbers in its own format in its own datafiles. Are you looking to hack the Oracle datafiles? Or do you have an input file in packed decimal format that your are looking at loading into Oracle? If you could tell us the objective you are seeking to achieve, perhaps we could help you. Or maybe not. :-) My schedule doesn't allow me much spare time to hack Oracle datafiles.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, October 09, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi, Is there any way to identify values in a field, defined in Oracle as number(11,2), with a packed decimal format? Or to update the field with packed decimal values? Thanks, Russ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).