When system tablespace is created?

0 Answers  

---

Point out the difference between user tables and data dictionary?

0 Answers  

---

What is a Shared SQL pool ?

2 Answers  

---

What are the differences between lov and list item?

0 Answers  

---

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  

---

10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.

3 Answers   Wipro,

---

20. Using a set operator, display the client number of all clients who have never placed an order.

0 Answers   Wipro,

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

How to use regular expression in pattern match conditions in oracle?

0 Answers  

---

Can we insert data in view oracle?

0 Answers  

---

write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000

4 Answers   TCS,

---

What is Water Mark in Oracle?

7 Answers   Oracle,

---