COMM
----------
SQL> declare
2 v_comm_percent constant number:=10;
3 begin
4 update emp
5 set comm=sal*v_comm_percent
6 where deptno=10;
7 end
8 /
end
*
ERROR 位于第 7 行:
ORA-06550: 第 7 行, 第 3 列:
PLS-00103: 出现符号 "end-of-file"在需要下列之一时：
;
符号 ";" 被替换为 "end-of-file" 后继续。
SQL> declare
2 v_comm_percent constant number:=10;
3 begin
4 update emp
5 set comm=sal*v_comm_percent
6 where deptno=10;
7 end;
8 /
PL/SQL 过程已成功完成。
SQL> select comm from emp where deptno=10;
COMM
----------
24500
50000
13000
SQL> select sal,comm from emp where deptno=10;
SAL COMM
---------- ----------
2450 24500
5000 50000
1300 13000
declare
v_comm_percent constant number:=10;
begin
update emp
set comm=sal*v_comm_percent
where deptno=10;
end;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/77164/viewspace-1008282/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- ORA-23515: 实体化视图和/或它们的索引存在于表空间中
- rac 缺失本地节点node1的信息
- ORA-01287 from a different database incarnation
- ORA-07445: exception encountered: [Address not mapped to object]
- ORA-06544: PL/SQL: internal error, arguments: [56319]
- ORA-01031 insufficient privileges
- ORA-00314: log 2 of thread 1, expected sequence# 53 doesn't match 2
- ORA-00600: internal error code, arguments: [4193],
- ORA-00313: open failed for members of log group
- ORA-01552: cannot use system rollback segment
