Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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