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
Answers were Sorted based on User's Feedback
Answer / murali mohan
Try this...Hope this will give the Required Answer
create table testsamp(a char,b char,c char);
insert into testsamp values ('A','B','C');
insert into testsamp values ('A','B','X');
select a,b,c from(
select a , b,
c||lead(c,1) over (partition by a,b order by a,b) c from
testsamp ) tmp where rownum=1;
Regards,
Murali
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / sreeharibabu g
select max(a),max(b),listagg(c,',') within group ( order by null) from testsamp group by a,b;
Is This Answer Correct ? | 0 Yes | 0 No |
How to create a temporary table in oracle?
interview questions with answer for cts
Explain the function of optimizer in oracle?
Give the different types of rollback segments.
What is dual table oracle?
What's dateware house and what's clustor with practicle example
what is the difference between dbms and rdbms?
Define Normalization with example?
types of indexes and the rationale behind choosing a particular index for a situation.
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
State all possible different index configurations a table can possibly have?
How to change program global area (pga) in oracle?