Daniel Morgan wrote:
> Frank van Bortel wrote:
>
>> <g> COuld you make that a regular? I'd like that.
>
>
> My pleasure. I can't remember if I've done this one before ... but in
> the US telephone numbers with area code are always in the form
> ###-###-####.
>
> Write a simple function that will return a Boolean (True/False) as to
> whether something has the format of a valid telephone number with area
> code. It must check for the following:
>
> Three integers between 0 and 9
> Followed by a dash '-'
> Followed by three integers between 0 and 9
> Followed by a dash '-'
> Followed by four integers
> The length must be 12.
>
> Hint: When I run the following query:
> select * from user_source where name = <function_name>;
> it returns only 7 lines of code.
>
Can I use 10g Regexs ?
Received on Wed Jan 28 2004 - 20:50:25 CST