DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Decimal to Packed format

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Decimal to Packed format

    Hello all..

    I have data in My Oracle DB in Decimal format. My main frame people want that column data to be given to them in Packed Decimal format..

    does oracle have any functions where we can convert data from decimal - to - Packed format ?

    thanks for you r help
    Ron

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool

    Quote Originally Posted by vr76413
    ...does oracle have any functions where we can convert data from decimal - to - Packed format ?
    NO, but you could code your own function.

    PS: Ask the "main frame people" how do they intend to convert the ASCII packed decimal to EBCDIC packed decimal?

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width