Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following source looking like below
column1 column2
101,102,103 abc,def,ghi
1001,1002,1003 a,b,c
i want the output
column1 column1
101 abc
102 def
103 ghi
1001 a
1002 b
1003 c
- 1 Answers
- 4449 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / farrukhshaikh
select vw1.str, vw2.str
from (select rownum sr,
substr(col,
instr(col, ',', 1, level) + 1,
instr(col, ',', 1, level + 1) -
instr(col, ',', 1, level) - 1) str
from (select ',' || qry || ',' col
from (select '101,102,103,1001,1002,1003'
qry from dual))
connect by level <= length(col) - length(replace
(col, ',')) - 1) vw1,
(select rownum sr,
substr(col,
instr(col, ',', 1, level) + 1,
instr(col, ',', 1, level + 1) -
instr(col, ',', 1, level) - 1) str
from (select ',' || qry || ',' col
from (select 'abc,def,ghi,a,b,c' qry from
dual))
connect by level <= length(col) - length(replace
(col, ',')) - 1) vw2
where vw1.sr = vw2.sr
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain parameter file in oracle.
What are the tools for Oracle ?
What is index-organized table in Oracle?
What language does oracle use?
How do I recompile a procedure in oracle?
What is set verify off in oracle?
How would you change old and new values in an insert, delete and update triggers?
How to write text literals in oracle?
Explain the use of record length option in exp command.
How to build data dictionary view an new database?
How to assign values to variables?
what is IDE,DMV in sql server?
How to rename a column in an existing table?
How do I call oracle stored procedures that take no parameters?
How to create a table interactively?
