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