摘要: OracleConnection connection = new OracleConnection(connectionString); --连接 connection.Open(); OracleCommand command = new OracleCommand(); command.Connection = connection; command.CommandText = "PACK_SIIT.getFlowTrack";--存储过程名 command.CommandType = CommandType.StoredProcedure;--设置执行为存储过程 c 阅读全文
posted @ 2011-03-15 15:34 尹庆超 阅读(3132) 评论(1) 推荐(0) 编辑
摘要: 1.parallel execution 并行执行2.strength优点 weakness缺点 seed潜能 virtue 品德 competence能力3. variable scn numberexec :scn:=dbms_flashback.get_system_change_number;select * from tablename as of scn :scn;select * from tablename as of timestamp sysdate-1/1440;select timestamp_to_scn(to_date('2010-01-01 10:10:1 阅读全文
posted @ 2011-03-15 13:31 尹庆超 阅读(250) 评论(0) 推荐(0) 编辑