Oracle-L: RE: Packed decimal

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 10 Oct 2002 06:28:27 -0800
Message-ID: <F001.004E595B.20021010062827@fatcity.com>

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.
dwilliams_at_lifetouch.com

-----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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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). Received on Thu Oct 10 2002 - 09:28:27 CDT