Oracle SQL - REGEXP LIKE contains characters other than a-z or A-Z

Question

I would like to create a query where I select all records which contain characters that are not a-z or A-Z  so something like this  SELECT   FROM mytable WHERE REGEXP LIKE column 1     A-Z   a-z

User · Accepted Answer

The   negates a character class   SELECT   FROM mytable WHERE REGEXP LIKE column 1     A-Za-z

User · Answer

Something like  select     from foo  where regexp like  col1       alpha           should work  SQL gt  create table foo  col1 varchar2 100      Table created   SQL gt  insert into foo values   abc      1 row created   SQL gt  insert into foo values   abc123      1 row created   SQL gt  insert into foo values   def      1 row created   SQL gt  select     2    from foo   3   where regexp like  col1       alpha          COL1 -------------------------------------------------------------------------------- abc123

User · Answer

if you want that not contains any of a-z and A-Z   SELECT   FROM mytable WHERE NOT REGEXP LIKE column 1    A-Za-z      something like    98763045098  or    436  7       or other languages like persian  arabic and     like this

User · Answer

Try this   select   from T PARTNER  where C DISTRIBUTOR TYPE ID   6 and translate C PARTNER ID    1234567890        is null

[sql] Oracle SQL - REGEXP_LIKE contains characters other than a-z or A-Z

Examples related to sql

Examples related to regex

Examples related to oracle