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.
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 normalisation in sql?
Why join is faster than subquery?
how do you know the version of your mysql server? : Sql dba
What are the query optimization techniques?
What are the different operators available in sql?
What are the limitations of sql express?
how to load data files into tables with 'mysqlimport'? : Sql dba
What is a .db file?
What is use of term?
List the various privileges that a user can grant to another user?
What is trigger in pl sql with examples?
What is the difference between stored procedure and view?
what are local and global variables and their differences? : Sql dba
what is query cache in mysql? : Sql dba
What is set serveroutput on?