Alter user-defined type to add a new attribute : Alter Type « Object Oriented Database « Oracle PL / SQL

1. Oracle PL / SQL
2. Object Oriented Database
3. Alter Type

Alter user-defined type to add a new attribute

 
SQL>
SQL>
SQL> create or replace type person as object(
  2   first_name varchar2(100),
  3   last_name varchar2(100) );
  4  /

SQL>
SQL>
SQL> alter type person add attribute ssn varchar2(11) INVALIDATE;

Type altered.

SQL>
SQL> drop type person;

Type dropped.

SQL>
SQL>

 

Related examples in the same category