Total Pageviews

January 6, 2019

1/06/2019 10:45:00 AM
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.
  1. SQL> SELECT F_empsal (P_A => 10, 20) FROM DUAL;
Related Posts Plugin for WordPress, Blogger...