DECLARE mKeyID INT;
begin
update hr_leave set NAME= '11' ,STATUS= '1' ,ID= '1' ,DEPARTMENT= '11' ,TIME= '11' ,EMPLOYEE= '11' where id='1';
mKeyID := 1;
update hr_leave_work set TIME= 'ggg' ,CONTENT= 'ffff' ,ID= '1' ,LID=@mKeyID,TITLE= 'ttt' where ID='1';
update hr_leave_work set TIME= '33' ,CONTENT= '3' ,ID= '3' ,LID=@mKeyID,TITLE= '3' where ID='3';
end;
以上是更新,执行也不通过,还有是插入,也不行,哪位给看下,更新和插入都可以执行的一次性执行的语句?
DECLARE mKeyID INT;
begin
insert hr_leave (id,name,status)values(seq_hr_leave.nextval,'aa','1');
select seq_hr_leave.currval into mKeyID from dual;
insert hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, @mKeyID,'ttt','2009');
insert hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, @mKeyID,'eee','2009');
end;
哪位知道这些简单的执行?能给个正确的?谢谢
begin
update hr_leave set NAME= '11' ,STATUS= '1' ,ID= '1' ,DEPARTMENT= '11' ,TIME= '11' ,EMPLOYEE= '11' where id='1';
mKeyID := 1;
update hr_leave_work set TIME= 'ggg' ,CONTENT= 'ffff' ,ID= '1' ,LID=@mKeyID,TITLE= 'ttt' where ID='1';
update hr_leave_work set TIME= '33' ,CONTENT= '3' ,ID= '3' ,LID=@mKeyID,TITLE= '3' where ID='3';
end;
以上是更新,执行也不通过,还有是插入,也不行,哪位给看下,更新和插入都可以执行的一次性执行的语句?
DECLARE mKeyID INT;
begin
insert hr_leave (id,name,status)values(seq_hr_leave.nextval,'aa','1');
select seq_hr_leave.currval into mKeyID from dual;
insert hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, @mKeyID,'ttt','2009');
insert hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, @mKeyID,'eee','2009');
end;
哪位知道这些简单的执行?能给个正确的?谢谢
解决方案 »
- 日期如何增加一年
- 为什么在pl/sql执行插入一个特定值时,语句就一直在执行中;而插入类似值就没问题
- excel导入oracle数据库乱序
- 关于数据库二进制字段的问题
- 求救oracle调用出错的问题,急急!!!
- 局域网内两台机子的SID相同能连吗???
- 有关oracle安装的问题,求救
- 在VB中连接Oracle的问题??请高手指点呀!Oracle真的好奇怪~~~
- 存储过程编码找出物料编码为“1”或“5”开头的物料对应的成本对象/产品为“8”或字母开头的成品关系;一共需出具2014-2017年4年对应清单
- mysql 单表级联删除
- 求个SQL的写法,看看有没有比较有效率的!
- PLSQL日期转换问题,各位兄弟都来帮我看看,在下感激不尽
begin
update hr_leave set NAME= '11' ,STATUS= '1' ,ID= '1' ,DEPARTMENT= '11' ,TIME= '11' ,EMPLOYEE= '11' where id='1';
mKeyID := 1;
update hr_leave_work set TIME= 'ggg' ,CONTENT= 'ffff' ,ID= '1' ,LID=mKeyID,TITLE= 'ttt' where ID='1';
update hr_leave_work set TIME= '33' ,CONTENT= '3' ,ID= '3' ,LID=mKeyID,TITLE= '3' where ID='3';
insert into hr_leave (id,name,status) values(seq_hr_leave.nextval,'aa','1');
select seq_hr_leave.currval into mKeyID from dual;
insert into hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, mKeyID,'ttt','2009');
insert into hr_leave_work (id,hr_leave_id,title,TIME) values(seq_hr_leave_work.nextval, mKeyID,'eee','2009');
end;
/ 1.insert后面掉了into
2.oracle不需像sqlserver那样变量前加@