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');