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 shutdown your 10g xe server from command line?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
Explain implicit cursor.
Which environment variables are absolutely critical in order to run the OUI?
difference between imlicit cursor and explicit cursor ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain the characteristics of oracle dba?
difference between procedures and function?
Explain the use of grant option in exp command.
what is data abstraction
Can we save images in a database and if yes, how?
Why do we use bulk collect in oracle?