BEGIN
INSERT INTO t_xxxxxxxxx
(Title, DepID, UserID, CreateDate, BDate, EDate, Content)
VALUES
('test',
21,
1,
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
'tttttttttttttttttttttt');
SELECT S_T_xxxxxxxxx.Currval FROM DUAL;
END;
上面的两条语句单独执行都没有问题,但是放在BEGIN和END;中就无法执行,说后面的SELECT语句缺乏INTO子句?对Oracle不熟悉,希望大家帮忙解决。谢谢!
INSERT INTO t_xxxxxxxxx
(Title, DepID, UserID, CreateDate, BDate, EDate, Content)
VALUES
('test',
21,
1,
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
TO_DATE('2006-5-5', 'yyyy-mm-dd hh24:mi:ss'),
'tttttttttttttttttttttt');
SELECT S_T_xxxxxxxxx.Currval FROM DUAL;
END;
上面的两条语句单独执行都没有问题,但是放在BEGIN和END;中就无法执行,说后面的SELECT语句缺乏INTO子句?对Oracle不熟悉,希望大家帮忙解决。谢谢!
SELECT FIELD_NAME INTO VAR FROM TABLE_NAME WHERE COND;
Oracle 还真是麻烦啊