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 are the two parts of design view?

579


What is #table in sql?

519


How to check if a column is nullable before setting to nullable?

580


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

611


Can we use joins in subquery?

531






What is a native sql query?

494


What are the subsets of sql?

547


Is a view faster than a stored procedure?

542


What is union and union all keyword in sql?

565


Can delete statement be rollbacked?

523


Is left join and outer join same?

544


How is a PL/SQL code compiled?

666


Is natural join and inner join same?

487


What is localdb mssqllocaldb?

615


What is procedure and function in sql?

532