今天开发问我: 为什么编译过不去,一看就知道是缺少引号,应该改成
4 R Q% @' r9 w set serveroutput on# M. b: M. v8 A3 L" ?
declare
^0 N5 d5 c& S7 n% ]9 O V3 |( [ abc VARCHAR2(2000);: ?2 t& F6 [+ ^9 |, C" {4 K
begin
3 [2 V8 t8 X+ k4 a+ b% c9 H/ G+ I" K TIME_D := 'select (sysdate - 8 / 24 - to_date('||CHR(39)||'1970-01-01'||CHR(39)||', '||CHR(39)||'yyyy-mm-dd'||CHR(39)||')) * 86400000 from dual';, Q# R& P6 ^3 X; K7 c
dbms_output.put_line(abc);
+ e8 o$ P% L5 ]) f. t0 s end;! x3 ?) G- V, ?' v5 j8 B/ x+ {
原来语句格式:
3 @. E) x6 ~3 c CREATE OR REPLACE TRIGGER tttest
0 ^4 b v5 J" {. t after INSERT
( n- K. k! m" L Z0 @) f [4 } ON test ]) o6 m2 R* G" ?; l. Z7 y% y
REFERENCING NEW AS New OLD AS Old( m( @- f/ S. U( [- l
FOR EACH ROW6 j0 g& Z, C! D: M, E$ Y: g
DECLARE1 V$ N) j1 |; l6 n5 |0 a U
TIME_D varchar2(30);8 g% \3 s3 O5 k
BEGIN5 M b( C, p5 U( p; l( m8 G/ w
TIME_D := select (sysdate - 8 / 24 - to_date('1970-01-01', 'yyyy-mm-dd')) * 86400000 from dual;
/ o. @$ C3 Q: R8 V. C END ; |