Oracle 活动架构对象

SQL> create view my_view as select * from dual;

View created.

SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';

  COUNT(*)
----------
         1

SQL> drop view my_view;

View dropped.

SQL> select count(*) from dba_objects where object_name = 'MY_VIEW';

  COUNT(*)
----------
         0

复制