“New” operators of PL/SQL

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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s