25/02/2013

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;

No comments:

Post a Comment

With great power comes great responsibility