create /alter proc nameof procedure as/is beging statment EXCEPTION en

What are the blocks in stored procedure?

Question Posted / sachin

Answer Posted / sachin

create /alter proc nameof procedure
as/is
beging
statment
EXCEPTION
end

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I view tables in sql developer?

518

Why do we need unique key in a table?

533

What is the maximum number of triggers, you can apply on a single table?

547

Which are sql * plus commands?

545

What is int identity in sql?

576

What is sql architecture?

563

What are properties of the transaction?

562

What is sql and how does it work?

555

How do you modify a column in sql?

541

What is spool?

601

Why stored procedures are faster than query?

580

What is sql prepared statement?

552

Explain cursor types?

587

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

580

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

608