This works perfectly fine for me in 10.2 select OWNER, TABLE_NAME from dba_TABLES where owner >= CHR(0) AND TABLE_NAME >= CHR(0) ORDER BY 1,2 On the other hand "null" is undefined. It's not CHR(0). On 8/2/07, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote: > > Hello > > What component in DB I have to install to use ">= CHR(0)" instead of > "is not null" . > > > > -- > Wojciech Skrzynecki > Database Administrator > -- > //www.freelists.org/webpage/oracle-l > > >