<div>
Hi SDSTUBER,<br />
<br />
This query works exactly for me, just like to know if I achieve this through outer joins...<br />
<br />
just like to have your expert opinion on this.
</div>


Hi SDSTUBER,

This query works exactly for me, just like to know if I achieve this through outer joins...

just like to have your expert opinion on this.

<div>
<div class="content wysiwyg-content">
I have records like below.<br />
<br />
col1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;col2<br />
11-Sep-14 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11-Oct-14<br />
15-Sep-14 18-Sep-14<br />
<br />
In the first row I am having col1 &amp;&nbsp;col2 in different months, so first record should be split like below<br />
<br />
col1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;col2<br />
11-sep-14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30-sep-2014<br />
1-oct-14 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11-oct-2014<br />
<br />
<br />
In the second row, I just have values from same month,<br />
so it should as it is. so altogether it should be 3 rows.
</div>
</div>


I have records like below.

col1	col2
11-Sep-14	 11-Oct-14
15-Sep-14 18-Sep-14

In the first row I am having col1 & col2 in different months, so first record should be split like below

col1                      col2
11-sep-14          30-sep-2014
1-oct-14             11-oct-2014


In the second row, I just have values from same month,
so it should as it is. so altogether it should be 3 rows.

Query to split one row to multiple rows.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.