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

Explain what is rdbms?

0 Answers  

---

How do you optimize a stored procedure in sql?

0 Answers  

---

what is HASH join?

2 Answers   Genpact, HCL,

---

How do I restart sql?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

---

1> how are u debugging in plsql ? 2> how to connect oracle database from unix. is there ne way other than using sqlplus ?

2 Answers  

---

How do I save a stored procedure?

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

how to fetch common records from two tables? : Sql dba

0 Answers  

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

Does sql view stored data?

0 Answers  

---

What are triggers and its types?

0 Answers  

---