CREATE TABLE TEMP
(
	COL1 VARCHAR2(10),
	COL2 VARCHAR2(10),
	COL3 VARCHAR2(10),
	COL4 VARCHAR2(10),
);

INSERT INTO TEMP VALUES ('Y','N','1','NAME1');
INSERT INTO TEMP VALUES ('Y','N','2','NAME2');
INSERT INTO TEMP VALUES ('Y','N','3','NAME3');
INSERT INTO TEMP VALUES ('N','Y','4','NAME4');

select * from temp
where
	(col1 = 'Y' or col2 = 'N')
		and col3 = '1';
		
select * from temp
where
	col1 = 'Y' or col2 = 'N'
		and col3 = '1';	

select * from temp
where col1 = 'Y' 
or (col2 = 'N' and col3 = '1');