Re: Oracle For Fun

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1075338777.438703_at_yasure>...
> 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.

function valid_code ( p_code in varchar2 ) return boolean
is
begin
  return translate(nvl(p_code,'?'),'0123456789#','##########?') = '###-###-####'; end;

Only 6 lines ;0) Received on Thu Jan 29 2004 - 05:01:54 CST