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 · 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

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

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

User · Answer

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

[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