December 2nd, 2011, 10:07 AM
Common Query for both oracle and mysql.
Select Empid Empname From Employee Where Emclass Is Not Null And Empclass <>' ' And Empclass <>'';
Above Query Run Well For Mysql.but Not For Oracle Because Oracle Does Not Support Empty String.
But I Need Common Query For Both Oracle And Mysql With All The Three Above Condition.
Please Help Me
January 27th, 2012, 01:29 AM
Your understanding is wrong regarding how oracle handles Empty String.
Originally Posted by mohdshahid
will work in both oracle and mysql.
Select Empid, Empname From Employee Where trim(Emclass) Is Not Null;