I'm currently creating a number of tables with columns that are nested tables.
It's good to see that PL/SQL Developer supports the use of these when querying the data.
Unfortunately the create/edit table window does not create the correct syntax to create a table containing a nested table.
It allows you to set the data type to that of the object I've already created, but the SQL generated doesn't include the clause:-
NESTED TABLE nested_table_column STORE AS nested_table_column_tab;
Is this likely to be added to a future release?
It's good to see that PL/SQL Developer supports the use of these when querying the data.
Unfortunately the create/edit table window does not create the correct syntax to create a table containing a nested table.
It allows you to set the data type to that of the object I've already created, but the SQL generated doesn't include the clause:-
NESTED TABLE nested_table_column STORE AS nested_table_column_tab;
Is this likely to be added to a future release?