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
- 5985 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 to show all tables with 'mysql'? : Sql dba
Why sql query is slow?
What is sqlerrm?
What do you mean by “trigger” in sql?
what is row? : Sql dba
Explain what is a database?
Is sql workbench free?
What are tables and fields in the database?
What is union and union all keyword in sql and what are their differences?
Is json a nosql?
What is query syntax?
What is row_number () in sql?
what is table? : Sql dba
How does sql developer connect to oracle database?
What is sql select statement?
