Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

0 Answers   TCS,

---

Explain the concept of the DUAL table.

2 Answers  

---

When do you get a .pll extension in oracle?

0 Answers  

---

Can we connect to ORACLE db using Windows Authentication?

0 Answers   MCN Solutions,

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,

---

How many categories of data types in oracle?

0 Answers  

---

How to write a query with a full outer join in oracle?

1 Answers  

---

How do I call oracle stored procedures that take no parameters?

0 Answers  

---

What is a package in oracle?

0 Answers  

---

what is the difference between no rows returned and null returned?

2 Answers  

---

which clause we are not used in where clause?

3 Answers   Semantic Space,

---

Explain oracle left join with an example?

0 Answers  

---