Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to alter object type?

LAVANKVOct 4 2012 — edited Oct 4 2012
I 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
This post has been answered by unknown-7404 on Oct 4 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2012
Added on Oct 4 2012
3 comments
432 views