Pages
Home
Legal
About me
How To
Source Code
Publications
Sheet music
Finance
Link dump
Comics
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
With great power comes great responsibility