Answer / subhash

PIVOT finction available from ORCLE 11g Onwards:

SELECT *
FROM (SELECT customer_id, customer_quantity
FROM pivot_test)
PIVOT (customer_quantity FOR (customer_quantity
) IN (101, 102, 103))
ORDER BY customer_id;


Output:
1 101 102 103

Answer / subhash

SELECT
CUST_ID,
DECODE(CUST_ID,'101',CUST_QUTY) AS CUST_QUTY1,
DECODE(CUST_ID,'102',CUST_QUTY) AS CUST_QUTY2,
DECODE(CUST_ID,'103',CUST_QUTY) AS CUST_QUTY3
FROM TABLE_NAME
GROUP BY CUST_ID;

Answer / srinu

select translate('1,101;1,102;1,103','1,101;1,102;1,103',1
101,102,103) from dual;

Have you used Unstructured data?

0 Answers   CTS,

---

How do u view log file for a particular job?

6 Answers   HP,

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---

what is use of SDR function?

0 Answers   CGI,

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

What are the processing stages?

0 Answers  

---

What is the difference between lookup and sparse lookup?

1 Answers  

---

how to write server Routine coding?

0 Answers   Eric,

---

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,

---

Can you explain link buffering?

0 Answers  

---

How To find the location of APT_confid file

2 Answers   CTS,

---