sql with regex

sgxbytes

Hi,

I have column values like ---- com.integrosys.sml.app.facility.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.facility.vo. OBFacility[5647].Pricing Result','[[:digit:]]{4}'

hope it helps

sql with regex

re: sql with regex

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about