demo07.sql

来自「VC++是微软公司开发的一个IDE(集成开发环境),换句话说,就是使用c++的一」· SQL 代码 · 共 42 行

create table t
as
select object_name unindexed,
       object_name indexed
  from all_objects
/
create index t_idx on t(indexed);
exec dbms_stats.gather_table_stats(user,'T');
select used_ublk
  from v$transaction
 where addr = (select taddr
                 from v$session
                where sid = (select sid
                               from v$mystat
                              where rownum = 1
                            )
              )
/
update t set unindexed = lower(unindexed);
select used_ublk
  from v$transaction
 where addr = (select taddr
                 from v$session
                where sid = (select sid
                               from v$mystat
                              where rownum = 1
                            )
              )
/
commit;
update t set indexed = lower(indexed);
select used_ublk
  from v$transaction
 where addr = (select taddr
                 from v$session
                where sid = (select sid
                               from v$mystat
                              where rownum = 1
                            )
              )
/