25/02/2013

Oracle get nested table element value without column name

In Oracle, if you have a nested table with a single unnamed column (usually named simply "element"), you can access its value by using the COLUMN_VALUE keyword:

SELECT nt.COLUMN_VALUE
FROM myTable t, TABLE(t.myNested) nt;

No comments:

Post a Comment

With great power comes great responsibility