What are the difference between Functions/Stored Procs and
Triggers and where are they used.
- 1 Answers
- 5140 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
What is the file extension for sql database?
Can we use ddl statements in stored procedure sql server?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What are the set operators in sql?
Determine if oracle date is on a weekend?
Can a table contain multiple foreign key’s?
What is the difference between a database and a relational database?
what are set operators in sql? : Sql dba
Explain select statements in sql?
Explain the types of joins in sql?
Which is faster subquery or join?
What is sharding in sql?
What is difference between sql and oracle?
How do I create a sql database?
Is coalesce faster than isnull?
