Select empid empname from employee where empclass is not null and empclass <> ' ' and empclass <>'';
this query is perfectly run in mysql.
But in oracle it return no records found.beacuse oracle does not support empty string.
Please provide me the equivalent query for oracle.