The PRODUCTS table is used to create the TPMRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function.
A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status of the dependent objects?
A. All dependent objects remain valid.
B. Only the procedure and function become invalid and must be recompiled.
C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
Answer: A
表增加字段，不影响视图的状态。
SQL> select object_name,status from user_objects where object_name like '%COW977%';
未选定行
SQL> create table cow977 ( a varchar2(10),b number(6),c number(6));
表已创建。
SQL> insert into cow977 values ('abc',1,2);
已创建 1 行。
SQL> commit;
提交完成。
SQL> create view cow977_v as select a,b,c from cow977;
视图已创建。
SQL> select object_name,status from user_objects where object_name like '%COW977%';
OBJECT_NAME STATUS
---------------------------------------- -------
COW977 VALID
COW977_V VALID
SQL> alter table cow977 add d number(6);
表已更改。
SQL> select object_name,status from user_objects where object_name like '%COW977%';
OBJECT_NAME STATUS
---------------------------------------- -------
COW977 VALID
COW977_V VALID
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2121719/ ，如需转载，请注明出处，否则将追究法律责任。
