1.

What are parameter modes in PL SQL functions and procedures?

Answer»

In PL/SQL, procedures support all the parameter MODES listed below, whereas, functions only support the IN parameter mode. Here are all the parameter modes in PL/SQL for procedures and functions:

  • IN: This is the DEFAULT mode, which allows the CALLING code to pass values in the procedures or functions.
  • OUT: The OUT PARAMETERS allow the procedures or functions to pass the values back towards the calling code.
  • IN OUT: The IN OUT parameters allow the calling code to pass the values in and also to receive values from procedures or functions.


Discussion

No Comment Found

Related InterviewSolutions