Alter a table with user-defined object to upgrade including data
SQL>
SQL> create or replace
2 type person as object(
3 first_name varchar2(100),
4 last_name varchar2(100) )
5 /
Type created.
SQL>
SQL>
SQL> create table person_table(
2 name person,
3 age number )
4 /
Table created.
SQL>
SQL>
SQL>
SQL> alter table person_table upgrade including data;
Table altered.
SQL>
SQL>
SQL> drop table person_table;
Table dropped.
SQL>
SQL>
SQL> drop type person;
Type dropped.
SQL>
SQL>
Related examples in the same category