Answer Posted / p.rajasekar

Function:
1.Function Always Return values
2.We can call the function in select Query
3.We can return more than one values using Out put
paramaetes
4.Genrally we can use function as calculatevalues
5.We can insert,update or delte value with the help
function in a select query
Procedure:
1.Procedure doesnot always return value
2.We can't call procedure in Select query
3.We can return more than one value using Out put
parameters in procedure
4.Genarally procudures are using as business logic

How to use sql statements in pl/sql?

1122

---

How can check sql version from command line?

1088

---

How to return multiple rows from the stored procedure?

970

---

What are triggers in sql?

1020

---

What is sql partition function?

1212

---

What is a join query?

964

---

How to read xml file in oracle pl sql?

913

---

what are the join types in tsql? : Transact sql

1064

---

What is difference between db2 and sql?

1001

---

Which are the different character-manipulation functions in sql?

1065

---

Can we use ddl statements in stored procedure?

1154

---

Why commit is not used in triggers?

1040

---

Is grant a ddl statement?

896

---

What is the use of index in sql?

1017

---

What is use of term?

1068

---