what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

How would you convert date into julian date format?

0 Answers  

---

How do I filter in sql profiler?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

what are the forced views

6 Answers   Hexaware, TCS,

---

What are the types of join and explain each?

0 Answers  

---

What is tuple in sql?

0 Answers  

---

How to fetch the rows by dynamicaly passing table name through cursor?

3 Answers  

---

How to select unique records from a table?

0 Answers  

---

What is group by in sql?

0 Answers  

---