在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的

在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的
在oracle中,怎么将一个OR作为一个and条件?
where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate
其实这个startDate和endDate的判断的这个or的结果是前面where整个条件中的一个and条件.请问这个该怎么写?

在oracle中,怎么将一个OR作为一个and条件?where pc.status = 2 and startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate其实这个startDate和endDate的判断的这个or的
where pc.status != 2 and (startDate between pc.projectStartDate and pc.projectEndDate or endDate between pc.projectStartDate and pc.projectEndDate)
-----------------------------这样也可以------------------------------------------------------
where pc.status != 2 and (( startDate between pc.projectStartDate and pc.projectEndDate) or (endDate between pc.projectStartDate and pc.projectEndDate))
--------------------------------
这个问题的分类应该是数据库软件编程的.