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

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

Differentiate between % rowtype and type record.

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

What is difference between left and right outer join?

0 Answers  

---

What is record data type?

0 Answers  

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

What is query execution plan in sql?

0 Answers  

---

Is sql a programming?

0 Answers  

---

What are the constraints available in sql?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---