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
- 2 Answers
- 3951 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
please explain.. DB architecture ...
What are nested tables?
Calculate difference between 2 date / times in oracle sql?
What is the relationship among database, tablespace and data file?
Can a formula column referred to columns in higher group ?
Explain the features of oracle?
What is data file?
What is the simplest tool to run commands on oracle servers?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What are dml statements in oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to do clean up if create database failed?
What are the different editions of oracle?
What is data block in Oracle?
State some uses of redo log files?
