[Oracle] oracle代码的常见错误汇总

insert into t1 values(...)

insert into t1(...) values(...)

to_char(sysdate,'YYYYMMDDHHMMSS')

to_char(sysdate,'YYYYMMDDHH24MISS')

select count(*) into v_count from t1 where c1=?;

select c1,c2 in from t1 where c3 = v_c3;
if v_c1 = 0 or v_c2 = 0 then

'... where c1 = ' || v_c1;

where c1 = '||chr(39) ||v_c1||chr(39);

select count(*)
into v_count
from t1
where c1 = v_c1;

WHERE EXISTS (SELECT *
FROM t1

WHERE EXISTS (SELECT 'x'
FROM t1

RAISE_APPLICATION_ERROR(-20000, infoMsg);