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
- 12209 Views
- Cap Gemini, MTS, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
create table test001 (cuss varchar2(10), acc varchar2(30));
insert into test001 values ('a','1');
insert into test001 values ('b','2|3');
insert into test001 values ('c','4|5|6');
WITH CTE AS (SELECT CUSS,ACC FROM TEST001)
select distinct trim(regexp_substr( acc, '[^|]+', 1,
level)) acc ,cuss from cte
CONNECT BY LEVEL <= LENGTH(REGEXP_REPLACE(ACC, '[^|]+')) +
1;
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is bulk collect in pl sql?
What are the types of sql commands?
What are all the different normalizations?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is set transaction?
how to analyze tables with 'mysqlcheck'? : Sql dba
How many functions are there in sql?
What is keys and its types?
Can you do multiple joins in sql?
how to decrement dates by 1 in mysql? : Sql dba
what is the difference between char_length and length? : Sql dba
Can %notfound return null after a fetch?
What are inbuilt functions in sql?
what is data integrity? : Sql dba
Is postgresql a server?
