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
Define tables and fields in a database
What is PL/SQL Records?
What does partition by mean in sql?
How sql query is executed?
How does stored procedure reduce network traffic?
Does oracle roll back the transaction on an error?
how to rename an existing table in mysql? : Sql dba
What is plpgsql language?
how to use 'mysql' to run sql statements? : Sql dba
What is aggregate function in sql?
Explain the update statement in sql
What will you get by the cursor attribute sql%notfound?
What are the sql versions?
What is cross join example?
What is a pl/sql block?