Basic Oracle Concepts and Programming Question:

Download Job Interview Questions and Answers PDF

What Are the Parameter Modes Supported by PL/SQL?

Oracle Database Interview Question
Oracle Database Interview Question

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.


Download Oracle Database Interview Questions And Answers PDF

Previous QuestionNext Question
What Is the Difference between Formal Parameters and Actual Parameters?How To Use "IN" Parameter Properly?