Basic Oracle Concepts and Programming Question:
What Are the Parameter Modes Supported by PL/SQL?
Answer:
PL/SQL supports 3 parameter modes on procedure/function parameters:
► IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function.
► OUT: OUT parameters allow the procedure or function to pass values back to the calling code.
► IN OUT: IN OUT parameters allow the calling code to pass values into and receive values from procedure or function.
► IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function.
► OUT: OUT parameters allow the procedure or function to pass values back to the calling code.
► IN OUT: IN OUT parameters allow the calling code to pass values into and receive values from procedure or function.
| Previous Question | Next Question |
| What Is the Difference between Formal Parameters and Actual Parameters? | How To Use "IN" Parameter Properly? |