what is difference between procedure and function,
procedure and trigger?
- 8 Answers
- 28600 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / suresh somayajula
Difference between Procs & Triggers is;
We have control over the firing of Stored Proceudres,
but we don't have control over the firing of Database
Triggers.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
Why do we need cursor in pl sql?
What is difference between cursor and trigger?
Are stored procedures compiled?
What is data profiling in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is synonyms?
What is %type in sql?
Is natural join same as inner join?
What is clustered and nonclustered index in sql?
Is sql sequential or random?
Can a table have no primary key?
What is trigger in flip flop?
What do you understand by case manipulation functions?
How long does it take to learn pl sql?
Can we write ddl statements in functions?
