Positional notation specify same parameters in same order - SQL Operations
Q. In which of the following, do you specify the same parameters in the same order as they are declared in the procedure?- Published on 09 Jul 15a. Positional notation
b. Named notation
c. Mixed notation
d. All mentioned above
ANSWER: Positional notation
Calling a stored procedure by simply just passing the parameter values and assuming that the values will be associated with the parameters in the order of the declaration is known as positional notation. In this notation the value which is passed first is associated with the first parameter, the second value with the second parameter and so on so forth. Here, the values must be passed in a proper order in a stored procedure.
