- 博客(2)
- 收藏
- 关注
原创 redo文件破坏恢复
1.正常关机情况下redo文件被破坏SQL> shutdown immediate;[oracle@localhost wangbeng]$ rm redo02*SQL> startupORACLE instance started.Total System Global Area 417546240 bytesFixed Size 2228944 bytesVaria
2014-02-26 11:20:04 781
原创 substr(a.object_name, 1, length(b.object_name)) = b.object_name 优化
今早在ITPUB上面看到一贴,思路不错记录下来。http://www.itpub.net/thread-1376537-1-1.htmlSQL> select a.*,b.object_name from test1 a,test2 b where substr(a.object_name,1,length(b.object_name)) = b.object_name;
2014-02-26 10:14:07 967
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人