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
6354 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

How do you modify a column in sql?

999

Can I join the same table twice?

1046

What is db journal file?

1067

explain the difference between delete , truncate and drop commands? : Sql dba

1094

What is relationship? How many types of relationship are there?

1184

How does sql developer connect to oracle database?

1005

what is the difference between blob and text? : Sql dba

1020

what is bcp? When does it used? : Sql dba

989

What are user defined functions?

1018

What are the key differences between SQL and PL SQL?

1216

What is the difference between left and left outer join?

945

What is error ora-12154: tns:could not resolve the connect identifier specified?

1081

What is not in sql?

950

explain the delete statements in sql

1061

Can we call a function containing dml statements in a select query?

980