In this Oracle PL/SQL Tutorial, We are sharing some Procedure Related Interview Questions in Oracle PL/SQL.
We hope this questions will help you in your Oracle PL/SQL Interview. In this post we are sharing most asked questions related to Procedure in Oracle PL/SQL.
Q1. What is Procedure in Oracle PL/SQL?
Q2. Syntax of Procedure in Oracle PL/SQL?
Q3. Example of Procedure in Oracle PL/SQL?
Q4. For which case, we used to Procedure in PL/SQL.
Q5. Can we use Out or InOUT Parameter in Procedure in PL/SQL and For which Purpose, we use OUT and InOut Parameter?
Q6. Can we use RETURN Keyword in Procedure and What is the purpose of RETURN Keyword?
Q7. Can we use function in the procedure in PL/SQL?
Q8. Can we write DDL process in Procedure in PL/SQL? If yes then how?
Q9. Can we use Procedure as an Assignment Statement or Boolean Expression or SQL Statement?
That's all for today, I hope this (Procedure Related Interview Questions in Oracle PL/SQL.) post will be helpful for you. If you want to know the answer then drop your comments in comment section.
2 Comments
hi, yes I want the answers
ReplyDeletei want the answers
ReplyDeleteIf you have any doubts, Please let me know