SELECT * FROM TT_NO T WHERE NOT REGEXP_LIKE(T.NO, '^[0-9]+');
--查找T.NO字段不是数字的数据, '^[0-9]+'匹配一行数字
SELECT * FROM TT_NO T WHERE NOT REGEXP_LIKE(T.NO, '^[0-9]+');
--查找T.NO字段不是数字的数据, '^[0-9]+'匹配一行数字
暂无评论
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2023-11-02
2024-05-20
2024-05-20
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-18
2024-05-17
2024-05-17
2024-05-17
2024-05-17
2024-05-17