1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the difference between Functions/Stored Procs and
Triggers and where are they used.

Question Posted / sql2000


What are the difference between Functions/Stored Procs and Triggers and where are they used...

Answer / 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

More SQL PLSQL Interview Questions

Does varchar need length?

0 Answers  

Name three sql operations that perform a sort.

0 Answers  

What are analytical functions in sql?

0 Answers  

how do you know if your mysql server is alive? : Sql dba

0 Answers  

define sql update statement ? : Sql dba

0 Answers  




Why do you partition data?

0 Answers  

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

Why is nosql good?

0 Answers  

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

What is full join?

0 Answers  

Explain dml and ddl?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories