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.

how to find 5th row ?

10 Answers  

---

How to find last day of the month in sql query

4 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

Is like operator in sql case sensitive?

0 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

What is oracle sql called?

0 Answers  

---

Which is faster union or join?

0 Answers  

---

How to make a copy values from one column to another in sql?

0 Answers  

---

what are tables and fields? : Sql dba

0 Answers  

---

What is latest version of sql?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---