Hi all,
In my 11R2 database I have a table with many rows. After SELECT * on the table I get the following output:
| ID | COL1 | COL2 | COL3 |
| 1 | 11111 | 22222 | 33333 |
| 2 | | 22223 | |
| 3 | 11112 | | 33334 |
| 4 | 11113 | | |
| 5 | 11114 | | 33335 |
With "ORDER BY ... NULLS LAST" I can order the values in the first, second, or ... column and the null rows will be shown at the end of the column. I would like to get the following output:
| ID | COL1 | COL2 | COL3 |
| 1 | 11111 | 22222 | 33333 |
| 2 | 11112 | 22223 | 33334 |
| 3 | 11113 | | 33335 |
| 4 | 11114 | | |
Is it possible to get this using SQL commandos?