Archive for the ‘oracle nested table’ tag
When is a nested table column null?
Somebody posted a comment that asked how you could test whether a nested table column is null. The NVL didn’t work because it doesn’t support the SQL data type.
I added how you could do it to an earlier blog post on joining non-collection row data to collection columns. The added entry shows you how to check whether a nested table column is null, empty, or populated. It’s a quick example that uses the same scalar collection of strings previously covered in that example.
Subscribe via RSS