下载地址:http://download.csdn.net/detail/iihero/4131001(免责声明): 这是一个精简版的oracle11g for windows 32bit x86平台.此压缩包,仅供学习研究使用,本文作者不负任何责任。适合于开发人员使用。切不可将其用于商业用途,请遵守Oracle公司相关商业规定。如因私自将其用于商业用途,由此带来...【阅读全文】
ORACLE 9及以上版本闪回,误删除恢复1)需要开户flashback功能select flashback_on from v$databaseflashback table TEST to timestamp to_Date('2013-07-13 16:08:00', 'yyyy-mm-dd hh24:mi:ss')或flashback table TEST to timestamp to_timestamp('2013-07-13 16:08:00','yyyy-mm-dd hh24:mi:ss');2)不需...【阅读全文】
Databases, tablespaces, and datafiles are closely related, but they have important differences:An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.Each tablespace in an Oracle database consists of one o...【阅读全文】
在ITPUB上遇到一个很有意思的问题(http://www.itpub.net/thread-1796130-1-1.html),对于表T,有object_id,按照where object_id =:oid查询,如果传入的oid是NULL,则查询全部(希望走全表扫描),相当于FROM t WHERE 1=1,如果object_id传入非NULL值(希望走索引扫描),则执行查询FROM t WHERE object_id =:oid,这是常见的根据传入的值不同,执行不同条件查询的语句。【阅读全文】