Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE T AS
WITH T AS
(
  SELECT LEVEL, TO_CHAR(SYSDATE + LEVEL, 'DY','NLS_DATE_LANGUAGE=ENGLISH') DY, 
         0 ME, 2 NONME
    FROM DUAL
  CONNECT BY LEVEL <= 10
)
SELECT * FROM T
    
10 rows affected

SELECT *
  FROM T
 WHERE ( NOT regexp_like(dy,'sat|sun','i') AND ME < NONME ) 
    OR ( NOT regexp_like(dy,'sat|fri','i') AND ME > NONME )
    


LEVEL
DY
ME
NONME


3
MON
0
2

4
TUE
0
2

5
WED
0
2

6
THU
0
2

7
FRI
0
2

10
MON
0
2


DROP TABLE T
CREATE TABLE T AS
WITH T AS
(
  SELECT LEVEL, TO_CHAR(SYSDATE + LEVEL, 'DY','NLS_DATE_LANGUAGE=ENGLISH') DY, 
         4 ME, 2 NONME
    FROM DUAL
  CONNECT BY LEVEL <= 10
)
SELECT * FROM T
10 rows affected

SELECT *
  FROM T
 WHERE ( NOT regexp_like(dy,'sat|sun','i') AND ME < NONME ) 
    OR ( NOT regexp_like(dy,'sat|fri','i') AND ME > NONME )
    


LEVEL
DY
ME
NONME


2
SUN
4
2

3
MON
4
2

4
TUE
4
2

5
WED
4
2

6
THU
4
2

9
SUN
4
2

10
MON
4
2