Oracle 中不是 REGEXP_LIKE

使用Oracle中的正则表达式函数进行模式匹配

REGEXP_LIKE (source_string, pattern, match_parameter)

sql
SELECT email
FROM employees
WHERE REGEXP_LIKE(email, '\.com$');

sql
SELECT product_code
FROM products
WHERE REGEXP_LIKE(product_code, '^[A-Z][0-9]{3}$');

sql
-- 创建一个示例表格
CREATE TABLE employees (
    id NUMBER,
    name VARCHAR2(100),
    email VARCHAR2(100)
);
-- 向表格中插入示例数据
INSERT INTO employees (id, name, email) VALUES (1, 'John Doe', 'john.doe@example.com');
INSERT INTO employees (id, name, email) VALUES (2, 'Jane Smith', 'jane.smith@example.com');
INSERT INTO employees (id, name, email) VALUES (3, 'Mike Johnson', 'mike.johnson@example.org');
-- 使用REGEXP_LIKE函数筛选出以".com"结尾的邮箱地址
SELECT email
FROM employees
WHERE REGEXP_LIKE(email, '\.com$');
-- 使用REGEXP_LIKE函数筛选出以字母开头，并且后面跟着3个数字的产品编号
CREATE TABLE products (
    id NUMBER,
    name VARCHAR2(100),
    product_code VARCHAR2(10)
);
INSERT INTO products (id, name, product_code) VALUES (1, 'Product 1', 'A123');
INSERT INTO products (id, name, product_code) VALUES (2, 'Product 2', 'B456');
INSERT INTO products (id, name, product_code) VALUES (3, 'Product 3', 'C789');
SELECT product_code
FROM products
WHERE REGEXP_LIKE(product_code, '^[A-Z][0-9]{3}$');