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.

empclass IS NOT NULL AND TRIM(empclass) IS NOT NULL

Thanks for your response aforin
but i want common query for both oracle and mysql having all the three conditions.

Hm ... you want the same query to run in both MySQL and Oracle?

yes aflorin

I don't know mySQL - what exactly returns TRIM(empty_string) in mySQL?