在PL/SQL中写了以下语句:update demoat3.bpartner B set bprnam_0=A.bprnam_0,bprsho_0=A.bprsho_0,bprlog_0=A.bprlog_0
from test.bpartner A
where B.bprnum_0=A.bprnum_0 AND A.bprnum_0 LIKE 'C02%'执行时报SQL命令未正确结束,请问下哪里有问题?谢谢!
from test.bpartner A
where B.bprnum_0=A.bprnum_0 AND A.bprnum_0 LIKE 'C02%'执行时报SQL命令未正确结束,请问下哪里有问题?谢谢!
解决方案 »
- 如何比较两个表的数据是否完全一致
- 求助一个简单的 PL/SQL编成 2
- Oracle日志如何查看
- DROP表后 在回收站里 怎么查到 并且还原
- 求MSSQL2005的存储过程转换成Oracle存储过程的工具
- 找出一个表中完全相同的记录-sql怎么写?
- Proc中的WHERE可以类似"Table.NAME=\"aaa\" or Table.NAME=\"bbb\""这样写吗
- 显示所有数据库的问题
- 求这个问题的解决方案!
- 十万火急求助:red hat linux 8.0 下如何安装oracle9.0或者8.0
- 关于PL/SQL编写的存储过程中,SQL语句的某些问题
- 求oracle shell编程资料
UPDATE "SCOTT"."EMP"
SET ("SAL",comm)=(select sal,comm from emp10 where empno=7499)
WHERE empno=7499;
set (bprnam_0,bprsho_0,bprlog_0)=
(select bprnam_0,bprsho_0,bprlog_0
from test.bpartner A
where B.bprnum_0=A.bprnum_0 AND A.bprnum_0 LIKE 'C02%')
set (B.bprnam_0,B.bprsho_0, B.bprlog_0)=( SELECT A.bprnam,A.bprsho_0, A.bprlog_0 FROM test.bpartner A
where A.bprnum_0=B.bprnum_0
AND A.bprnum_0 LIKE 'C02%' )
where exists ( select 1 from test.bpartner C where C.bprnum_0=B.bprnum_0
AND C.bprnum_0 LIKE 'C02%' );
set B.bprsho_0=(select A.bprsho_0 from test.bpartner A where A.bprnum_0=B.bprnum_0),
B.bprlog_0=(select A.bprlog_0 from test.bpartner A where A.bprnum_0=B.bprnum_0)
where B.bprnum_0 LIKE 'C02%'
才转过来搞ORACLE,各位见笑了。