Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

How to check Null/WhiteSpaces/Empty Values in Oracle Query

If you have requirement to filter records where some columnName is either having value Null or have WhiteSpaces or is Empty, you can use following query: SELECT columnName FROM tableName WHERE TRIM(columnName) IS NULL Simil...
Sign In

Sign up using

Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: