Oracle SQL : 11g features Mixed Notation

Named and Mixed notation

Oracle 11g SQL now supports the function call with both named and positioned parameters. This is known as mixed notation of a function call in an SQL statement.

A function F_empsal in  the Example Code accepts two parameters to count the numbers prime numbers between the ranges.

Example 

1. SQL> SELECT F_empsal (P_A => 10, 20) FROM DUAL;