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

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

Is microsoft sql free?

0 Answers  

---

What is an escape character in sql?

0 Answers  

---

What is the purpose of cursors in pl/sql?

0 Answers  

---

How do you rename a table in sql?

0 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

Which join is like an inner join?

0 Answers  

---

What steps server process has to take to execute an update statement?

0 Answers  

---

Are subqueries better than joins?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

Is sql a backend?

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---