select * from ( select 'DIAG01_CD' AS TEST from dual union all select 'DIAG02_CD' AS TEST from dual union all select 'DIAG03_CD' AS TEST from dual union all select 'DIAG10_CD' AS TEST from dual union all select 'DIAG10_AIS_CD' AS TEST from dual )A where REGEXP_LIKE(TEST,'^DIAG[0-9]|_CD$')
정규식을 사용해서 DIAG01~10_CD같은 패턴만 검색을 하고싶은데
계속 DIAG10_AIS_CD 해당 데이터도 같이 출력이되네요..
DIAG02_CD 데이터만 뽑아낼수있는 정규식 조언해주시면 감사하겠습니다!