sql with regex

[sgxbytes]

Hi,

I have column values like ---- com.integrosys. sml.app.facilit y.vo.OBFacility[5647].Pricing Result

in my table .

i need to write a sql query fetching only the number inside the square braces(5647).

how to use regex for this .i am using oracle 10g

regards
Raj

[Saii]

regexp_substr(' com.integrosys. sml.app.facilit y.vo.OBFacility[5647].Pricing Result','[[:digit:]]{4}'

hope it helps