• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

signed decimal sql standard datatype?

I have lines in a csv like these:

07/09/2002,'ORDER POSTING',-5,'TMT',0.463,10.8,0
01/06/2003,'ORDER POSTING',75.76,'C',-2.4524,37.4,15.96
--'Date','Description','Amount','Symbol','Quantity','Price','Commission'

The quantity column is negative for a withdrawal (sell stocks), positive otherwise.  I have no other way with this data set to see if withdrawal/deposit.  any hope of a signed decimal datatype for this?  There is too much precision for "money" datatype.  I am using pgsql

muchas gracias,

joe
0
joesp
Asked:
joesp
1 Solution
 
musduCommented:
Hi,

NUMBER datatype can hold both positive and negative numbers on Oracle.

regards.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now