Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two parts of a procedure ?
- 6 Answers
- 15955 Views
- Hi Caliber IT, I also Faced
- E-Mail Answers
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 inner join and outer join?
What is indexes?
How to run sql functions in pl/sql?
Explain the order of sql statement execution?
What is materialized view. What are different methods of refresh?
What is the difference between a subquery and a join?
How to place comments in pl/sql?
What is the difference between the conventional and direct path loader? : aql loader
What is ttitle and btitle?
What is denormalization in a database?
how to drop an existing index in mysql? : Sql dba
What are database links used for?
Explain what is a subquery ?
How do I view a view in sql?
what are null values? : Sql dba
