What are the blocks in stored procedure?

Answer Posted / swapnareddy

Declaration Block(optional)
Begin
Executable Block
exception Block(optional)
end;

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you create an empty table from an existing table? : Sql dba

659


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

508


what is myisam? : Sql dba

578


What is rownum and rowid?

570


tell us something about heap tables. : Sql dba

603






What are its different types of dbms?

540


What jobs use sql?

531


what is bdb (berkeleydb)? : Sql dba

574


What is parallel hint?

750


Does pl sql work in mysql?

536


What is recursive join in sql?

550


What are types of exception?

539


How to run sql statements with oracle sql developer?

625


What is the difference between instead of trigger and after trigger?

514


What is the largest value that can be stored in a byte data field?

518