Interested to Buy Any Domain ? << Click Here >> for more details...
What are the difference between Functions/Stored Procs and
Triggers and where are they used.
- 1 Answers
- 6002 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
Can there be 2 primary keys in a table?
what is oltp (online transaction processing)? : Sql dba
what is the syntax for using sql_variant_property? : Transact sql
What is the difference between microsoft access and sql?
What are sql indexes?
Do foreign keys improve performance?
What are different sql data types?
Why use stored procedures?
Is left join same as join?
Why is the cursor important?
How do I clear the screen in sql plus?
What are the qualities of 2nf?
describe transaction-safe table types in mysql : sql dba
What is a function in oracle pl sql?
Can we use loop in sql?
