SQL Interview Questions and Answers

by
sql interview questions and answers
Contents hide
1 SQL Interview Questions and Answers

SQL Interview Questions and Answers

Question: What is recursive stored procedure in Oracle PL/SQL ?
Answer:  Recursive PL/SQL stored procedure in Oracle means a stored procedure which calls by itself until it reaches some boundary condition.
Example:
create or replace procedure fact ( x in number, f out number )
as
Begin
if x = 0 then
f := 1;
else
fact(x-1, f);
f := x * f;
end if;
End;
/

—Call Above Procedure from Anonymous PL/SQL Blocks
Declare
z number;
begin
fact(5, z);
dbms_output.put_line(z);
End;
/

Please let us know, through your comments, which PDF Notes you want. We will try our level best to provide you that study material for your preparation not for commercial use. If  You want to share Your Study Material with Other Aspirants Please send Us at upscpdf2@gmail.com Please share this post with the needy aspirants.

Art and culture handwritten notes

114