Interested to Buy Any Domain ? << Click Here >> for more details...
What are the two parts of a procedure ?
- 6 Answers
- 16248 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
Is left join faster than inner join?
What is the difference between a primary key and a unique key?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
Are sql database names case sensitive?
What is sql server and ase?
Explain spool.
What are the subsets of sql?
How is a PL/SQL code compiled?
What are the methods of filing?
How do I run a program in pl sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Can we use delete in merge statement?
how to convert character strings to dates? : Sql dba
Can you call pl/sql package functions from within a fast formula?
Why use subqueries instead of joins?
