For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
How to fetch decimal part of a number in pl sql.
for e.g.
In case of 1234.768 return value should be 768
But if number is 1234 then should return null or zero.
How to achieve this in oracle pl sql query