RE: Packed decimal

[Karniotis, Stephen]

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:                      [EMAIL PROTECTED] Web:                        www.compuware.com   -----Original Message----- From: Brooks, Russ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 3:09 PM To: Multiple recipients of list ORACLE-L Subject: Packed decimal   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.