What are the two parts of a procedure ?
Answer Posted / kirankumar.vangeti
create or replace procedure procedure_name as
Declare
/* Declarative section: variables, types, and local sub
programs */
Begin
/* Executable section: Procedural and sql statements go
here */
Exception
/* exception handling section: error handling statements go
here */
End;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is commit? : Sql dba
how to decrement dates by 1 in mysql? : Sql dba
What are the types of queries in sql?
Can we update views in sql?
What is relationship? How many types of relationship are there?
what are the differences between char and varchar? : Sql dba
How do I remove sql plus from windows 10?
How to run pl/sql statements in sql*plus?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What does the hierarchical profiler does?
How does sql profiler work?
what is sql in mysql? : Sql dba
how would concatenate strings in mysql? : Sql dba
What is meaning of <> in sql?
Name the different types of indexes in sql and define them.