[待整理]oracle10g删除(释放)数据文件/表空间流程
1.获取开启select 'alter table ' || owner || '.'|| table_name || ' enable row movement; ' from dba_tables where tablespace_name='USERS';select 'alter table ' || owner || '.'|| table_name || ' shrink space CASCADE; ' from dba_tables where tablespace_name='USERS';oracle删除(释放)数据文件/表空间...
EXISTS 与 IN
select t1.* from t1 where not exists (select 1 from t2 where t2.a = t1.a) where exists (select ...), select 有记录则结果为真,相当于 where 1 = 1where not exists (select ...),select有记录则结果为假,相当于 where 1 = 2
ruby
gem install mysql2 -Vbundle install