Oracle 10g: column is blank, but is not null or an empty string

sql oracle

Issue this query:

SELECT column, DUMP(column, 1016)FROM table

It'll show the exact contents.

Related: Oracle does not allow empty strings; they're silently converted to NULL.

sql oracle

Maybe the column contains only spaces?

Did you try

select * from table where trim(column) is null

sql oracle

Oracle's got a basically permanent annoyance that empty strings are treated as null. However, are you sure that's an empty string? It could be an otherwise invisible character, such as a space or tab/linebreak/linefeed/etc... What does the string length show when you do select length(column) from table?

CodeHunter

Oracle 10g: column is blank, but is not null or an empty string

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last