What are the difference between Functions/Stored Procs and
Triggers and where are they used.
- 1 Answers
- 5161 Views
- CGI, TCS, I also Faced
- E-Mail Answers
Answer Posted / barun
Function-1.function used for calculation perpose.it must
return value.(call by pl/sql code block,by sql query)
Procedure-it is used to implement business logic.it may or
not return value.it pre compile and stored in server data
base.so it is faster.(call by pl/sql code block_
trigger-it is used to implement business logic and maintain
intigrity.it cant take any para-meter like fun or
procedure.it is automatically fired(implicitely)
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do I view a procedure in sql?
What is the difference between rename and alias?
What is meant by <> in sql?
Why stored procedure is better than query?
Differentiate between sga and pga.
Can a key be both primary and foreign?
what is a trigger? : Sql dba
Why we use join in sql?
What is schema in sql example?
Is not equal in sql?
How can you load microsoft excel data into oracle? : aql loader
Are sql connections encrypted?
What is the source code of a program?
What is the full form of sql?
Can we write ddl statements in functions?
