程序人生

摘要： http://www.oracle.com/technetwork/database/enterprise-edition/documentation/index.html 阅读全文

摘要： 1 PowerDesigner中批量根据对象的name生成comment的脚本执行方法：Open PDM -- Tools -- Execute Commands -- Run ScriptVb script代码 Option ExplicitValidationMode = TrueInteractiveMode = im_BatchDim mdl 'the current model'get the current active modelSet mdl = ActiveModelIf (mdl Is Nothing) ThenMsgBox "There is n 阅读全文

摘要： 2).检查Flashback功能，缺省时功能是关闭的。SQL>selectname,current_scn,flashback_onfromv$database;NAMECURRENT_SCNFLASHBACK_ON-------------------------------------DBA945715NO3).启动Flashback功能SQL>alterdatabaseflashbackon;数据库已更改。SQL>selectname,current_scn,flashback_onfromv$database;NAMECURRENT_SCNFLASHBACK_ON-- 阅读全文

摘要： select * from v$transactionSELECT s.sid, s.serial#, CASE BITAND(t.flag, POWER(2, 28)) WHEN 0 THEN 'READ COMMITTED' ELSE 'SERIALIZABLE' END AS isolation_levelFROM v$transaction t JOIN v$session s ON t.addr = s.taddr AND s.sid = sys_context('USERENV', 'SID');declare tra 阅读全文

摘要： select * from v$transactionSELECT s.sid, s.serial#, CASE BITAND(t.flag, POWER(2, 28)) WHEN 0 THEN 'READ COMMITTED' ELSE 'SERIALIZABLE' END AS isolation_levelFROM v$transaction t JOIN v$session s ON t.addr = s.taddr AND s.sid = sys_context('USERENV', 'SID');declare tra 阅读全文

摘要： SQL> alter table dossier set unused(address); 将列置为不可用。表已更改。 SQL> alter table dossier drop unused columns; 删除不可用的列。当生产的时候,更长表字段 阅读全文