Answer / Amrit Kalash

No, you cannot directly join two tables without a common column. However, you can use techniques such as full outer joins with a dummy/sentinel value in one of the tables to achieve the effect of joining tables without a common column.

What is the use of %rowtype?

1 Answers  

---

What is dcl in sql?

1 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

Explain the the update statement in sql?

1 Answers  

---

What port does sql server use?

1 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

How do you update a value in sql?

1 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1 Answers  

---

Explain the select statement in sql?

1 Answers  

---

How to rename a table?

1 Answers  

---

Determine if oracle date is on a weekend?

1 Answers  

---

What are the sql versions?

1 Answers  

---