Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert Mainframe Packed Decimal to Oralce Number Format

555459Jan 10 2007 — edited Jan 11 2007

Dear all,
I am having a file in which amount fields are given in a Packed Decimal format. Can anyone suggest me how I can read this data element from the file and convert it into Oracle Number datatype.

File is a fixed length. All the amount fields are given in Packed Decimal Format and rest of the fields are given in text format.

Thanks and regards
Nagasayan Puppala

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2007

Added on Jan 10 2007

#database-and-application-migrations

4 comments

14,953 views