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

1. Oracle PL / SQL
2. Select Query
3. Like

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