New PL/SQL “operators” discovered by Elic @ SQL.ru
SQL> exec x := 1 2
BEGIN x := 1 2; END;
*
ERROR at line 1:
ORA-06550: line 1, column 14:
PLS-00103: Encountered the symbol "2" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_
The symbol "*" was substituted for "2" to continue.
SQL> exec dbms_output.put_line(132 mod 10); dbms_output.put_line(132 rem 10); dbms_output.put_line(132 remainder 10)
2
2
2PL/SQL procedure successfully completed.
