MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

When is a nested table column null?

without comments

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.

Written by maclochlainn

December 24th, 2008 at 8:44 pm

Posted in Oracle,sql

Tagged with

Leave a Reply