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)

How can I delete duplicate rows?

0 Answers  

---

How does pl sql work?

0 Answers  

---

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

How to write html code in pl sql?

0 Answers  

---

How do you explain an index number?

0 Answers  

---

What is the requirement of self-join?

0 Answers  

---

Does varchar need length?

0 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

what is a tablespace? : Sql dba

0 Answers  

---

what is sql profiler

2 Answers   Fidelity,

---

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

---