In Oracle PL/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think.

Which one of these calls is better? Oracle doesn’t mind. To the PL/SQL engine they are all valid and all correct. I don’t even think there is a performance issue with either one of them.

Consider the betwnstr function and these calls (all have the same result) :

Read the rest of the article at http://bar-solutions.com/wordpress/?p=158