Answer Posted / harsha

Yes We can have multiple SP's with same name.This is called
overloading a Procedure with different parameters.
e.g. CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER);
CREATE PROCEDURE COMPUTE_AREA (LENGTH IN NUMBER,
WIDTH IN NUMBER
UNITS IN NUMBER);

What is java sql drivermanager?

1091

---

What are the uses of sysdate and user keywords?

1103

---

what are date and time data types in mysql? : Sql dba

971

---

What are three advantages to using sql?

1019

---

What is database white box testing and black box testing?

1110

---

What are the disadvantages of file system?

1267

---

What is insert command in sql?

1127

---

what is row? : Sql dba

1226

---

How to write pl sql program in mysql command prompt?

1095

---

What is a unique key?

1054

---

what is a constraint? : Sql dba

1166

---

what are the features and advantages of object-oriented programming? : Sql dba

1006

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2111

---

Can we join more than 2 tables in sql?

1019

---

What is parameter substitution in sql?

1027

---