declare cursor user defined exception variable begin sql statement pl

What are the components of a PL/SQL block ?

Question Posted / vijay_1994

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is a database event trigger?

1085

How delete a row in sql?

929

Is time a data type in sql?

853

What are three advantages to using sql?

961

What is acid property in a database?

973

what is index? : Sql dba

945

Why do we need pl sql?

937

What are the different types of joins in sql?

1659

What is bitemporal narrowing?

1231

How do I quit sql?

899

Explain the difference between sql and mysql.

1003

What is forward declaration in pl sql?

1008

How do you drop a trigger?

924

Which command is used to call a stored procedure?

954

what is self-join? : Sql dba

1057