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 do you remove duplicates without using distinct in sql?

0 Answers  

---

What does desc stand for?

0 Answers  

---

What is sql*plus?

0 Answers  

---

What is where clause in sql?

0 Answers  

---

what is the difference between clustered and non clustered index in sql? : Sql dba

0 Answers  

---

What is plpgsql language?

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

how to analyze tables with 'mysqlcheck'? : Sql dba

0 Answers  

---

What is the main reason behind using an index?

0 Answers  

---

Differentiate between % rowtype and type record.

0 Answers  

---

Why trigger is used in sql?

0 Answers  

---