What are the blocks in stored procedure?

Answer Posted / eshwer

Declaration block
Execution block
Exception block

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of joins?

532


How do you remove duplicates without using distinct in sql?

499


What are different methods to trace the pl/sql code?

536


What is primary key and foreign key with example?

494


How do you know if a relationship is 2nf?

518






Is sql a scripting language?

513


What is java sql connection?

511


How do you create an update query?

520


what are string data types? : Sql dba

510


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

595


Explain the commit statement.

611


What does plv msg allows you to do?

673


Which constraints we can use while creating database in sql?

612


What is a null value?

655


What is sql*loader and what is it used for? : aql loader

618