Get value to the right of the decimal point.

[Sajuks]

Hi there,
Select 10/11 from dual returns 0.909
What i would like to get using a single select is the value
"909"
.
TIA

Regards

 

[lewisp]

[tt]SELECT Substr(To_Char(10/11),
Instr(To_Char(10/11),'.') + 1,3)
FROM SYS.DUAL;[/tt]

 

[ddrillich]

select trunc(10/11*1000) from dual;