I am getting an error ORA-00920: invalid relational operator

select SID from APPLY
where CName ='STANFORD' OR'CORNELL' OR 'MIT';

>Solution :

Use the IN operator:

SELECT sid
FROM   apply
WHERE  cname IN ('STANFORD', 'CORNELL', 'MIT');

or, use multiple comparisons:

SELECT sid
FROM   apply
WHERE  cname = 'STANFORD'
OR     cname = 'CORNELL'
OR     cname = 'MIT';