Oracle Database Discussions

Hi,

I want to insert money values on a Oracle database and need an accuracy of four decimal places. Is NUMBER(19,4) the correct type?

Given this PL code:

create table foo (money_col number(19,4));

DECLARE
i PLS_INTEGER;
BEGIN
FOR i IN 1..10000 LOOP
    INSERT INTO FOO VALUES(i/10000);
END LOOP;    
COMMIT;
END;
/

Will it always insert 10.000 different numbers?

Thanks in advance,

Jose Luis