Need a simple SQL

[stecal]

No need for nulls - you can break on the name.

SQL> break on ename
SQL> select * from emp3;

EMP_NO ENAME
---------- ----------------
100 Johnny
100
100