How to write signed numeric?
From: Spencer H Moore <Spencer.H.Moore_at_tek.com>
Date: 1995/04/06
Message-ID: <Spencer.H.Moore.33.2F84722D_at_tek.com>#1/1
Date: 1995/04/06
Message-ID: <Spencer.H.Moore.33.2F84722D_at_tek.com>#1/1
I need to create an export file from Oracle that will be read by a COBOL-based
mainframe system. Several of the fields are "signed numeric". I believe this
means that the last byte of the field is an alphanumeric character such as
"A", "J", "}", etc., depending upon the sign and value.
Does anyone have an algorithm to convert a number to a "signed numeric"
string in PL/SQL? I searched the FAQ and couldn't find anything (probably
Thanks in advance.
Spencer Moore
ARIS Corporation
Received on Thu Apr 06 1995 - 00:00:00 CEST