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)

What is difference between procedure and trigger?

0 Answers  

---

How can you load microsoft excel data into oracle? : aql loader

0 Answers  

---

How pl/sql source code can be protected?

3 Answers  

---

how to dump a table to a file with 'mysqldump'? : Sql dba

0 Answers  

---

What is the purpose of a secondary key?

0 Answers  

---

Explain mutating table error.

0 Answers  

---

Is a table valued function object?

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---

How do you write an inner join query?

0 Answers  

---

what is table? : Sql dba

0 Answers  

---

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

---

State the difference between implict and explict cursor's?

7 Answers   CTS,

---