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 triggers in sql?

583

How does a trigger work?

538

what is a tablespace? : Sql dba

564

What are the ddl commands?

537

Explain what is a view?

600

Is sql procedural language?

554

What is difference between inner join and self join?

595

How to run sql commands in sql*plus?

589

what is rollback? : Sql dba

595

What is procedure function?

541

What is sql table?

523

What is normalisation and its types?

550

What is sql dialect?

531

How can a function retun more than one value in oracle with proper example?

588

How does postgresql compare to "nosql"?

582