A function using the LIKE operator to return a phone number's area code : Like « Select Query « Oracle PL / SQL






A function using the LIKE operator to return a phone number's area code

   
SQL>
SQL> -- A function using the LIKE operator to return a phone number's area code.
SQL>
SQL> CREATE OR REPLACE FUNCTION area_code (phone_number IN VARCHAR2)
  2  RETURN VARCHAR2 AS
  3  BEGIN
  4     IF phone_number LIKE '___-___-____' THEN
  5
  6       RETURN SUBSTR(phone_number,1,3);
  7     ELSE
  8      --there is no area code
  9       RETURN 'none';
 10     END IF;
 11  END;
 12  /

Function created.

SQL>
SQL>
SQL> select area_code('123456789') from dual;

AREA_CODE('123456789')
--------------------------------------------------------------------------------
none

SQL>
SQL>
SQL> select area_code('123-456-7890') from dual;


           
         
    
    
  








Related examples in the same category

1.Like with '__' (Any two characters)
2.Like with '_' and '%'
3.Use two '%' in Like statement
4.Using a NOT operator with like
5.Convert varchar value to upper case and then use like operator
6.Is Like case sensitive
7.Use % in word ending
8.Use two % signs in one like
9.Use two % signs in like
10.Like '%' function with varchar2 type
11.Like with % on both sides
12.Second letter is A
13.Create pattern dynamically and use it in like statement
14.Pattern Matching LIKE '%great%'
15.Using Pattern Matching LIKE '____ %'
16.comments like '%0\%%' escape '\'
17.Escape \
18.Description has 'SQL' substring