oracle_sqlplus -variable、define..

一、sqlplus中使用variable来定义

SQL> variable i number;  
SQL> exec :i :=1;  
SQL> select * from t where id=:i;  

二、sqlplus中通过define定义的并不是变量，而只是字符常量

   SQL> define a=1  
   SQL> define  
   SQL> select * from t where id=&a;  
   SQL> select * from t where id=&&b;  

三、oracle在解析sql时会把plsql中定义的变量转为绑定变量

SQL> alter session set sql_trace=true;  

Session altered.  

SQL> declare  
  2  begin  
  3  for i in 1 .. 100 loop  
  4  insert into tt values(i,'test');  
  5  end loop;  
  6  commit;  
  7  end;  
  8  /  

PL/SQL procedure successfully completed.  

SQL> alter session set sql_trace=false;  

Session altered.  

oracle表回滚到一个指定时间的操作语句

 SQL> alter table 表名 enable row movement;
 SQL> flashback table 表名 to timestamp to_timestamp('2011-03-04 05:00:00','yyyy-mm-dd HH24:MI:SS');