Oracle : Number of fractional digit(s) for a number

Here is the way:

SELECT cashAmnt,  length(MOD(abs(cashAmnt),1))-1 FROM sales;

Works on negative numbers also