Increment function in plsql

Question

In most programming languages, you have a quick way to write the increment for a variable, for example, the following examples:

inc(variableName); variableName++; variableName += 1; 

What methods exist in Oracle Pl / Sql to do this, and not use the following:

 variableName := variableName + 1; 

Answer 1

The operators are listed in the documentation .

There is no equivalent to ++ or += . I'm afraid you have to do it a long way.

You can write your own inc() function, but this will probably make your code less readable to others, as it will be non-standard.