What are parameter modes in PL SQL functions and procedures?
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.
BY Best Interview Question ON 27 Jun 2020