查询语句存档

https://onecompiler.com/

https://www.db-fiddle.com/

select regexp_count('1', '1') from dual;
select regexp_count('1', '?1'), regexp_count('1', '1?') from dual;


select regexp_like('1', '1?');
select regexp_like('1', '?1');

select '1' rlike '1?';
select '1' rlike  '?1';

select '1' regexp '1?';
select '1' regexp '?1';


select regexp_count('1', '*1') from dual;
select regexp_count('1', '+1') from dual;
select regexp_count('1', '{1}1') from dual;
select regexp_count('1', '{1,1}1') from dual;
select regexp_count('1', '{1,}1') from dual;
select regexp_count('1', '?{1}1') from dual;
select regexp_count('1', '?+{1,1}1') from dual;


select regexp_like('1', '*') from dual;
select regexp_like('1', '*');

select '1' rlike '*';
select '1' rlike '*' from dual;

select '1' regexp '*';
select '1' regexp '*' from dual;

select '1' like '*';
select '1' like '*' from dual;

SELECT 
    IIF('a' LIKE 'ap{,3}', 1, 0) AS any_matcht;


select regexp_like('a', 'ap{,3}');
select regexp_like('a', 'ap{,3}') from dual;

select 'a' rlike 'ap{,3}';
select 'a' rlike 'ap{,3}' from dual;


select 'a' regexp 'ap{,3}';
select 'a' regexp 'ap{,3}' from dual;

select 'a' like 'ap{,3}';
select 'a' like 'ap{,3}' from dual;


SELECT 
    CASE WHEN 'a' LIKE 'ap{,3}' THEN 1 ELSE 0 END AS is_match;