Oracle-L: RE: Packed decimal

From: Karniotis, Stephen <Stephen_Karniotis_at_compuware.com>
Date: Wed, 09 Oct 2002 12:24:10 -0800
Message-ID: <F001.004E4D92.20021009122410@fatcity.com>

Oracle uses a proprietary field format for numbers. I don't think it is packed decimal, however, I believe most of the Cobol or PL/I programs I wrote against Oracle RDBMS on the mainframe used Packed Decimal to represent number fields. You can use the SIGN function to determine the sign of the value, if that's what you are looking for.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:                   (248) 865-4350
Mobile:                  (248) 408-2918
Email:                      Stephen.Karniotis_at_Compuware.com
Web:                        www.compuware.com

-----Original Message-----
Sent: Wednesday, October 09, 2002 3: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

The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Karniotis, Stephen
INET: Stephen_Karniotis_at_compuware.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 Wed Oct 09 2002 - 15:24:10 CDT