Let me present a scenario:
I have a type:
create or replace type last_line_t is object
(
city varchar2(100),
state varchar2(100),
zip zip_code_t
)
and I have a table type
create or replace type last_line_nt is table of last_line_t;
I want to edit the type by adding a city_state_key varchar(100) element.
I have two options:
1) I can drop the last_line_nt and add my constraint and add back the last_line_nt, which becomes a big pain when you have more than 2 or 3 dependancies.
OR
2) In 9i, I can use the "ALTER TYPE" command:
ALTER TYPE ADD ATTRIBUTE(city_state_key varchar2(100);
******************
** MY QUESTION: **
******************
Does PL/SQL Developer support changing object types in any other manner? It seems like you could handle all of the object manipulation in the background (probably by method 1) and all I would do is change an attribute without any problem.
I have a type:
create or replace type last_line_t is object
(
city varchar2(100),
state varchar2(100),
zip zip_code_t
)
and I have a table type
create or replace type last_line_nt is table of last_line_t;
I want to edit the type by adding a city_state_key varchar(100) element.
I have two options:
1) I can drop the last_line_nt and add my constraint and add back the last_line_nt, which becomes a big pain when you have more than 2 or 3 dependancies.
OR
2) In 9i, I can use the "ALTER TYPE" command:
ALTER TYPE ADD ATTRIBUTE(city_state_key varchar2(100);
******************
** MY QUESTION: **
******************
Does PL/SQL Developer support changing object types in any other manner? It seems like you could handle all of the object manipulation in the background (probably by method 1) and all I would do is change an attribute without any problem.
