If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X

2 Answers  

---

Explain the use of ignore option in imp command.

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

What is the difference between sharding and partitioning?

0 Answers  

---

Explain integrity constraints?

0 Answers  

---

Can group functions be used in the order by clause in oracle?

0 Answers  

---

what is data independence exactly? give an example

6 Answers  

---

What are the different types of modules in oracle forms?

0 Answers  

---

Compare and contrast between sql and sql server and explain its various functions?

0 Answers  

---

What is redo log?

0 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

What are virtual columns?

2 Answers   TCS,

---