Declare section --- declaring the variables --- Begin section --- exe

What are the components of a PL/SQL block ?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

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

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Will truncate release space?

887

What does pl sql stand for?

1063

What is scalar data type in pl sql?

1019

What is java sql package?

1024

Explain the order of sql statement execution?

977

what is sub-query? : Transact sql

1039

What are the rules to be applied to nulls whilst doing comparisons?

1273

how to drop an existing index in mysql? : Sql dba

1017

Can procedure in package be overloaded?

1029

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What is cursor and its types?

995

What are tables and fields?

973

What is a table?

956

How do I write a sql query in pgadmin 4?

924

Can we use join in subquery?

1022