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

Compare sql & pl/sql

1131

What does seeding a database mean?

952

How to test for null values?

1044

How to convert comma separated string to array in pl/sql?

1177

How to return multiple rows from the stored procedure?

968

Can procedure in package be overloaded?

1083

How can a pl sql block be executed?

944

What is sql constant?

1026

Explain cursor types?

1019

What is the difference between delete, truncate and drop command?

1147

what are the different type of normalization? : Sql dba

1026

How to Execute a Package in PL/SQL.?

1198

what is rollback? : Sql dba

1104

What are the built in functions of sql?

1027

What are the query optimization techniques?

933