oracle 恢复数据

select dbms_flashback.get_system_change_number from dual;

select count(*) from t_bd_bank as of scn 168425870;

insert into t_bd_bank ( select * from t_bd_bank as of scn 168425870);

select * from back_bd_bank AS OF TIMESTAMP TO_TIMESTAMP('2008-11-19 20:08:00','YYYY-MM-DD HH24:MI:SS');

FLASHBACK TABLE back_bd_bank TO BEFORE DROP;

ksql example:

/*dialect*/ :提示ksql不翻译 web

script example:

Packages.com.kingdee.eas.fm.common.FMHelper.gc()

frame = new java.awt.Frame("JavaScript")
frame.show()

单元测试

Packages.junit.textui.TestRunner.run(Packages.com.kingdee.eas.basedata.assistant.TestBankAccount);

Oracle script example:

-------oracle top 25:
/*dialect*/SELECT * FROM (SELECT sql_text, GREATEST (GREATEST (disk_reads, 0) /DECODE (GREATEST (executions, 0),0, -1, executions), 0 ) t FROM v$sql s WHERE parsing_user_id <> 0AND command_type <= 7ORDER BY t DESC)WHERE ROWNUM <= 25

set autotrace on

set autotrace on traceonly

MSsql server example:

SET SHOWPLAN_ALL { ON | OFF }

SET STATISTICS PROFILE { ON | OFF }

SET PARSEONLY { ON | OFF }

explain plan set statement_id = '111' for select * from t_nt_nttype

select * from plan_table