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 the difference between clustered and non clustered index in sql? : Sql dba
What are the types of optimization?
How to order siblings in oracle hierarchy queries?
Why sql query is slow?
what are all types of user defined functions? : Sql dba
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Can %notfound return null after a fetch?
What is crud stand for?
How to rename a column in the output of sql query?
What is linq to sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Explain table and field in sql?
What is the plv (pl/vision) package offers?
explain the delete statements in sql
What type of join is sql join?