Oracle test if nested table has elements

If you're using nested tables in Oracle and need to check wether they're empty or not, you can use the IS EMPTY statement:

SELECT nt.*
FROM myTable t, TABLE(t.myNested) nt
WHERE t.myNested IS [NOT] EMPTY;