Is left join inner or outer by default?

0 Answers  

---

What is the difference between sql, mysql and sql server?

0 Answers  

---

What does cursor do in sql?

0 Answers  

---

What are the constraints available in sql?

0 Answers  

---

How do you use collections in procedure to return the resultset?

0 Answers  

---

What is substitution variable in pl sql?

0 Answers  

---

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

0 Answers  

---

what are all the different normalizations? : Sql dba

0 Answers  

---

What is dynamic SQl and how you will create and execute dynamic sql?

2 Answers   TCS,

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

0 Answers  

---