Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12613 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
Does a primary key have to be a number?
Is primary key always clustered index?
What are local and global variables and their differences?
How can I tell if sql is running?
What is the source code of a program?
what is sub-query? : Transact sql
what is 'mysqlimport'? : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
How many types of indexes are there in sql?
What is sql exception?
Can one improve the performance of sql*loader? : aql loader
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How to run sql functions in pl/sql?
What do you think about pl/sql?
How to make a copy values from one column to another in sql?
