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






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

Alter a user-defined type

 
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>
SQL> alter type person
  2  add attribute dob date
  3  cascade not including table data
  4  /

Type altered.

SQL>








Related examples in the same category

1.Alter user-defined type to add a new attribute
2.ALTER TYPE to add more methods and attributes