Home » Other » Training & Certification » Parameters Passing - Difference between Postional, Named, and Combination Methods (Oracle 10g, Windows XP)
Parameters Passing - Difference between Postional, Named, and Combination Methods [message #290951] Wed, 02 January 2008 05:02 Go to next message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

In Creating Procedures,
we are just passing parameters for business purpose. I have come to know about there are three ways for passing parameters.
1. Positional
2. Named
3. Combination.

I am not sure about this topic. let me know the application and examples of this three Methods.

Regards,
Suresh.
Re: Parameters Passing - Difference between Postional, Named, and Combination Methods [message #290954 is a reply to message #290951] Wed, 02 January 2008 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference
Chapter 8 Using PL/SQL Subprograms
Section Passing Parameters to PL/SQL Subprograms
Subsection Using Positional, Named, or Mixed Notation for Subprogram Parameters

Just read the documentation.
And don't try to fool us saying your homeworks are business needs this is just ridiculous.

Regards
Michel
Re: Parameters Passing - Difference between Postional, Named, and Combination Methods [message #290973 is a reply to message #290954] Wed, 02 January 2008 07:35 Go to previous message
cgmsuresh
Messages: 29
Registered: December 2007
Location: http://maps.google.com/ma...
Junior Member

Michel

Thanks. I am newbie to PL/SQL. thats only i am asking this type of question. I am not trying to fool you man. i am just learning here. any way, thanks for for your reply.

Regards,
Suresh.
Previous Topic: How to get the correct tree structure?
Next Topic: A Querry
Goto Forum:
  


Current Time: Thu Nov 21 14:14:01 CST 2024