title: SQL Datatype to use when inserting money
body: <p>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?</p>
  
  <p>Data input format: £00,000.000</p>
  
  <pre><code>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)
                     );
  </code></pre>