Select mobile from emp table number is Saudi line, number is STC company line, number contains number 1 twice, number does not contain number 9.

SELECT mobile

    FROM emp

   WHERE     mobile LIKE '00966%'

         AND SUBSTR (mobile, 6, 2) IN (50, 55, 53)

         AND mobile NOT LIKE '%9%'

  HAVING REGEXP_COUNT (mobile,

                       '1',

                       1,

                       'i') = 2

GROUP BY mobile