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;
哪位知道这些简单的执行?能给个正确的?谢谢
解决方案 »
- Oracle11g ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务
- 2条分页,求差别,结果不一样,rownum注意什么地方
- proc一个奇怪的问题
- oracle 连接的问题
- 关于oracle中的空字符串的处理
- 有关触发器问题(从Erwin导入Oracle数据库时产生触发器问题)?
- 在oracle8.0.5 for NT中如何启动和查看数据库(在线等待)
- 在PRO*C下怎样把字符串转换为数字?itoa不可以用吗?为什么我一调用就告诉我没有声明?
- 客户端安装oracle 91.0.2ids能否连接8.1.7的服务端?
- 如何安装 nt 或2000 server (为运行oracle)
- 求个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那样变量前加@