oracle regexp_not like
时间: 2023-11-23 10:08:45 浏览: 150
ORACLE正则表达式
Oracle does not have a built-in function called `regexp_not like`. However, you can achieve a similar result by using the negation operator (`NOT`) with the `REGEXP_LIKE` function. Here's an example:
```sql
SELECT *
FROM your_table
WHERE NOT REGEXP_LIKE(your_column, 'your_pattern');
```
In the above query, `your_table` is the name of your table, `your_column` is the column you want to match against the regular expression pattern, and `your_pattern` is the regular expression pattern you want to exclude.
This query will return all the rows where the column value does not match the specified regular expression pattern.
阅读全文