Friday 25 May 2012

Which of the following is a correct option to input a parameter to a procedure from a calling block? | PL SQL

a.    Studentjd OUT STUDENT.STUDENTJD%TYPE
b.    Studentjd IN OUT NUMBER (2)
c.    STUDENT OUT NUMBER
d.    STUDENT IN STUDENT.STUDENT JD%TYPE
 Option d is correct because it uses the IN parameter mode and defines the parameter using the %TYPE datatype for the STUDENTJD column in the STUDENT table.