What are the blocks in stored procedure?

Answer Posted / sachin

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is forward declaration in pl sql?

590


How do you run a query?

589


What is the sql*loader? : aql loader

589


What is the maximum rows in csv?

486


How to pipe multiline string to isql?

580






Why is theta join required?

664


What is sql data?

553


How does one load ebcdic data? : aql loader

654


What are keys in sql?

551


How can you save or place your msg in a table?

523


how to use like conditions? : Sql dba

575


what is the difference between myisam static and myisam dynamic? : Sql dba

585


What do you mean by “trigger” in sql?

623


Can we create index on primary key?

524


How do you delete data from a table?

546