Answer / lavanya

functions:
1.The parameters are input values and output values
2.The functions will return a value
3.The functions will be called with in sql

Procedures:
1.The parameters are input values and output values
2.The procedures will not return any value
3.The procedures will not be called with in sql

Answer / iamanocp

Proceure performs an action and function returns a value.
Both have different syntax for creation. Fucntion has
RETURN clause in its declaration.

Is stored procedure faster than query?

0 Answers  

---

what are the different index configurations a table can have? : Sql dba

0 Answers  

---

Are stored procedures faster than dynamic sql?

0 Answers  

---

Can we use insert statement in function?

0 Answers  

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

What is procedure explain with program?

0 Answers  

---

Which one is better sql or oracle?

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

Does sql*plus also have a pl/sql engine?

0 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

What is a file delimiter?

0 Answers  

---