select decode(cust,'a',acc) as A ,decode(cust,'b',acc)

. have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.
CUST ACC
a dv
b fg
b bh
c mk
c cl
c so
result:-
A B c
dv fg mk
bh cl
so

Question Posted / barun

3 Answers
6292 Views
I also Faced
E-Mail Answers

Answer Posted / barun

select decode(cust,'a',acc) as A ,decode(cust,'b',acc) as B,decode(cust,'c',acc) AS C from customer

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between sql and mysql?

1102

What is sql basics?

1029

what is the difference between truncate and drop statements? : Sql dba

1097

How can we solve sql error: ora-00904: invalid identifier?

1235

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

990

Is it possible to update views?

946

what is the difference between join and union? : Sql dba

1089

What if we write return in procedure?

1400

What is the difference between delete and truncate statement in sql?

1045

What type of database is sql?

1016

What is rownum in sql?

1008

What are synonyms in sql?

954

Which is faster count (*) or count 1?

1009

What is the difference between null value, zero, and blank space?

1186

How do you update sql?

955