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.

what is meant by tuning and tk proof?

2 Answers  

---

Write the command to remove all players named sachin from the players table.

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

How to look at the current sql*plus system settings?

0 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

How many developers work on postgresql?

0 Answers  

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

Can we enter data in a table in design view?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---