Nested Tables

Frodo

Member
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?
 
Back
Top