Field type suitable for saving currency in Oracle

Question

Field type suitable for saving currency in Oracle

Navigation

#1 by (2 votes)
#2 by (0 votes)

-1

Is there any problem in saving data with a comma or period (.) in my database (SQL Developer)? What is the most appropriate variable to declare for currency (price) fields?

sql tipagem oracle

asked by anonymous 15.10.2016 / 01:58

2 answers

What is the command in linux to copy the contents of a folder to another folder [closed] How to remove the br br information from maps?

score 2 · Answer 1

You can record any data in the database, it depends on what you want.

The correct column type for saving money is % with% of houses fixed . Example:

NUMBER(19, 4)

This allows 19 digits with 4 in the decimal part.

Be careful not to use wrong type and get hurt .

score 0 · Answer 2

To declare currency fields, you'd better use a Decimal / Numeric so you can set the decimal places.

Now for the field with commas or point you have to see the size of the field, if it is a larger text you should use a field of type Blob if you can not use a varchar. But you must be very careful when doing the queries.