How to find alphabetic characters (a-z, A-Z)
By using '[[:alpha:]]' with regular expressions it is possible to findalphabetic characters. By adding {3} at the end we limit the length of matchingalphabetic characters.
Select * from test_table where REGEXP_LIKE(test_column, '[[:alpha:]]');Select * from test_table where REGEXP_LIKE(test_column, '[[:alpha:]]{3}');
No comments:
Post a Comment