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)

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

---

how to create a database in oracle?

3 Answers  

---

What is the Query to print out the individual total number of duplicate row in sql.

5 Answers   TCS,

---

How to trace the errors in pl/sql block code?

5 Answers   TCS,

---

Does truncate require commit?

0 Answers  

---

what is difference between decode and case function?

2 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---

Is sql port 1433 encrypted?

0 Answers  

---

Is json a nosql?

0 Answers  

---

how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

What is a left inner join?

0 Answers  

---