URGENT. How do i find continuous number i a column??

URGENT. How do i find continuous number i a column??

 

  


Hi gurus,

I need to find continuous numbers in rows in a table.
I need to find sets of 10 numbers.

It's phonenumbers, that i need to find sets of. The phonenumber starts with 505 and is 8 charachter long.
The phonenumber column i varchar datatype.

Hope you can help me

Lars
Denmark

Oracle LazyDBA home page