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
- 4875 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 are the uses of Database Trigger ?
How to use an explicit cursor without open statements?
Explain the use of log option in exp command.
Design database draw er diagram for a certain scenario ?
Explain overloading. Can functions be overloaded?
How to write a left outer join with the where clause in oracle?
How can we find out the duplicate values in an oracle table?
What is meant by raw datatype?
How many categories of data types in oracle?
What is merge statement used for?
Where are the settings stored for each instance in oracle?
How to define default values for formal parameters?
What is background process in Oracle?
What language does oracle use?
what are steps for interface? where is exchange rate defined in which table?
