How to Whole number and Decimal number

 select '123.4512' num, substr('123.4512',1,instr('123.4512','.')-1) wholenum, substr('123.4512',instr('123.4512','.')+1) decimalpart from dual