I need to combine two rows based on the date into one row. Here is the source table

| MDATE | LID | VALUE1 |
| --- | --- | --- |
| 01-SEP-21 | 1 | 1231 |
| 01-SEP-21 | 2 | 2342 |
| 02-SEP-21 | 1 | 4561 |
| 02-SEP-21 | 2 | 6782 |
| 03-SEP-21 | 1 | 8901 |
| 03-SEP-21 | 2 | 9992 |

And I am expecting result as:

| MDATE | LID | VALUE1 | MDATE | LID | VALUE1 |
| --- | --- | --- | --- | --- | --- |
| 01-SEP-21 | 1 | 1231 | 01-SEP-21 | 2 | 2342 |
| 02-SEP-21 | 1 | 4561 | 02-SEP-21 | 2 | 6782 |
| 03-SEP-21 | 1 | 8901 | 03-SEP-21 | 2 | 9992 |

I can use two CTEs to get the desired result. However, is there any other way w/o using CTE?

Code in [db<>fiddle](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=60d7dc974d240a8899b2e8d514a79505)

Thanks.