SQL Datatype to use when inserting money

Question

I am using Oracle SQL database and I have to insert a monetary value(salary) as part of a row. For some strange reason the money command isnt working, is there any alternates that would work with this?

Data input format: £00,000.000

CREATE TABLE staff
                   (staffno CHAR(6) NOT NULL
                    , staffsurname VARCHAR(8) NOT NULL
                    , staffforename VARCHAR(7) NOT NULL
                    , salary MONEY NOT NULL
                    , PRIMARY KEY (staffno)
                   );

Answer 1

Look at this line

salary MONEY NOT NULL

There is no existing money datatype.

If you are looking for something similar to SQL-Server small money type, you want to use a Number(10,4) and then format the number.

You can format the number using to_char function

select to_char(yourColumn, '$99,999.99') from yourTable where someCondition