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);

Can we call a function containing dml statements in a select query?

917

---

Can we use join in subquery?

1022

---

How many types of cursors are available in pl/sql?

1042

---

What is a null value?

1084

---

What is delete command in sql?

1051

---

What is a delimiter in sas?

978

---

What are all different types of collation sensitivity?

973

---

What is primary key and foreign key?

915

---

what does the t-sql command ident_current does? : Transact sql

928

---

How do I run sql profiler?

1007

---

What is full join?

896

---

Does user triggers have entry for trigger with compilation errors?

973

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

931

---

Mention what are different methods to trace the pl/sql code?

1102

---

What is the difference between clustered and non-clustered index in sql?

957

---