Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4999 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between alert log file and tarce file ?
How to see free space of each tablespace?
How to drop an index?
What are the various types of snapshots ?
How to write text literals in oracle?
What is the meaning of recursive hints in oracle?
Can multiple columns be used in group by in oracle?
Explain the use of control file?
Explain the difference between sap and oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What exactly do quotation marks around the table name do?
What is a cursor variable?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Explain overloading. Can functions be overloaded?
How to write a query with a left outer join in oracle?
