NULL COLLATION IN ORACLE 8

[Dave_A]

Try order by col1, nvl(col2, low_value)

In your example, if it is character data, then the lowest value is 'a', so use

order by col1, nvl(col2, 'a')

HTH

David.