How to alter object type?
LAVANKVOct 4 2012 — edited Oct 4 2012I have a object type as shown below:
Below is the Object and its type
create or replace type test_object1 as object
(
val1 varchar2(50),
val2 varchar2(50),
val3 varchar2(50)
);
create or replace type test_type1 is table of test_object1;
Now I would like to alter the object type. I want to increase the size of val1 to varchar2(100).
Could any body help for the alter script.
Thanks,
Lavan