I have a tablle like this.
cust acc
---------------
a 1
b 2|3
c 4|5|6
I Want below o/p:
cust acc
-----------
a 1
b 2
b 3
c 4
c 5
c 6
Please any one can you have any ideas share me.
I have urgent requirement.
- 4 Answers
- 11014 Views
- Cap Gemini, MTS, I also Faced
- E-Mail Answers
Answer Posted / p deshmukh
SELECT distinct COL, trim(regexp_substr(colvalue, '[^|]+', 1, level)) colvalue
FROM (with demo as ( select '1' as a, '2|3' as b, '4|5|6' as c from dual )
select * from demo
unpivot
( colvalue for col in (a, b, c) )) t
CONNECT BY instr(colvalue, '|', 1, level - 1) > 0
order by col
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is rdbms? : Sql dba
What are hotfixes and patches?
What is set transaction?
What does select count (*) mean in sql?
What are types of indexes in sql?
What is a primary key? Explain
What is execute immediate?
What is sqlca in db2?
How long does it take to learn pl sql?
how to fetch common records from two tables? : Sql dba
Could you please provide oca (oracle 10g) dumps for my certification ?
How many commands are in sql?
What are the uses of sysdate and user keywords?
What are character functions?
What does pl sql stand for?
