Oracle equivalent to MS-Access character range/set In MS-Access, I can use character ranges/sets in the where clause:

SELECT
    table_name
FROM 
    all_tab_columns
WHERE
        table_name NOT LIKE 'A[0-9]*' 
    AND table_name NOT LIKE 'D[0-9]*' 
    AND table_name NOT LIKE 'S[0-9]*'


The character range/set is the range of numbers between 0-9. All tables that start with A, D or S, followed by a number, are eliminated from the query.

How can I do this in Oracle?
Use regular expressions:

SELECT
    table_name
FROM 
    all_tab_columns
WHERE
    NOT REGEXP_LIKE(table_name,'^(A|D|S)[0-9]')