BUG: command window and nulls

[Christo Kutrovsky]

When there's only one column, and it has NULL in it, PL/SQL deeloper's command window doesn't show it properly.

SQL> insert into kutro values (1);

1 row inserted

SQL> insert into kutro values (2);

1 row inserted

SQL> insert into kutro values (NULL);

1 row inserted

SQL> select * from kutro order by 1 desc;

A
----------
2
1

SQL> select * from kutro order by 1;

A
----------
1
2

SQL> select * from kutro order by 1 nulls first;

A
----------
1
2

SQL> select t.*, 'AAA' from kutro t order by 1;

A 'AAA'
---------- -----
1 AAA
2 AAA
AAA

SQL> select t.*, 'AAA' from kutro t order by 1 desc;

A 'AAA'
---------- -----
AAA
2 AAA
1 AAA

SQL>

 

[Christo Kutrovsky]

Ah sorry, forgot the PRE tag, don't know if it will work.

So those with the nulls, you can't see them properly, let me try again:

SQL> select t.*, 'AAA' from kutro t order by 1;

         A 'AAA'
---------- -----
         1 AAA
         2 AAA
           AAA

SQL> select t.*, 'AAA' from kutro t order by 1 desc;

         A 'AAA'
---------- -----
           AAA
         2 AAA
         1 AAA

SQL>

 

[Marco Kalter]

You're right, the empty lines are somehow suppressed. We'll fix it.