What are the components of a PL/SQL block ?

Question Posted / guest

3 Answers
11630 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the components of a PL/SQL block ?..

Answer / a.jyothsna

Declare section
---
declaring the variables
---
Begin section
---
executable statements
---
Exception section
---
exception handlers
---
end;

Is This Answer Correct ?

10 Yes

0 No

What are the components of a PL/SQL block ?..

Answer / nishi

Declare section

---

declaring the variables

---

Begin section

---

executable statements

---

Exception section

---

exception handlers

---

end;

Is This Answer Correct ?

1 Yes

0 No

What are the components of a PL/SQL block ?..

Answer / vijay_1994

declare
cursor
user defined exception
variable
begin
sql statement
plsql statement (application wise/business logic)
exception
end;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer