SQL & PL/SQL

Hi guys,

can someone explain why this syntax is incorrect?

SQL> select 1 from dual where (1,2)=(1,2);
select 1 from dual where (1,2)=(1,2)
                               *
ERRORE alla riga 1:
ORA-00920: operatore relazionale non valido

while the following one is correct?

SQL> select 1 from dual where (1,2) in ((1,2));

         1
----------
         1

Thanks,
Max
[My Italian Oracle blog|http://oracleitalia.wordpress.com]