Answer / venkat

Overloading a procedure/function means using the same
procedure/function name for various set of operations
depending upon the type and number of parameters.

it is modified based on ankita. Parameter is a correct word
for it.

Answer / ankita

Overloading a procedure/function means using the same
procedure/function name for various set of operations
depending upon the type and number of inputs.

Answer / polisetti v v satyanarayana

Actually there is difference between function and procedure
i.e procedure is a function but it will never return any
value but where as function will return the value and
overloading means using the using the same function name
with difference in number of parameters to have more
flexibility .For overloading functions compiler will us the
technique called name mangling

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

0 Answers  

---

How can the performance of a trigger be improved?

0 Answers  

---

What is the use of function in sql?

0 Answers  

---

what is sql in mysql? : Sql dba

0 Answers  

---

What is a native sql query?

0 Answers  

---

---

What is orm in sql?

0 Answers  

---

What is the Diff b/w Constraints and Trigeer

4 Answers   HCL,

---

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers  

---

What is schema in sql?

0 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

What is secondary key?

0 Answers  

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---