declaration part; begin executable part; exception handling; end;

What is the basic structure of PL/SQL ?

Question Posted / menan

Answer Posted / menan

declaration part;
begin
executable part;
exception handling;
end;

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sql*plus environment variables?

1093

What does count (*) do in sql?

1011

Does mysql support pl sql?

1171

Why self join is used in sql?

976

What is mutating error in pl sql?

1015

what are aggregate and scalar functions? : Sql dba

1057

Explain what is a field in a database and record in a database?

1097

What is schema in sql?

948

Is vs as in pl sql?

984

What is on delete restrict?

1000

When you have to use a default "rollback to" savepoint of plvlog?

1191

What are joins in sql?

1044

What is sql clause?

1048

Can we call dml statement in function?

1055

Is a view faster than a stored procedure?

970