我原来在SQL Server区问的(看错区了,呵呵),两位热心的朋友告诉我的都不行,他们是这样说的:
update register
set customerid=right('0000'+rtrim(c.BRANCH_NO),4)+right(c.CUSTOM_NO,8)
from f_cust c
where register.iDCard is not null
and register.iDCard=c.CAupdate r
set customerid=
CASE len(rtrim(c.BRANCH_NO))
when 1 then '000'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
when 2 then '00'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
when 3 then '0'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
ELSE rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
END
from register r,f_cust c
where r.iDCard is not null
and r.iDCard=c.CA可是我都报错:ORA-00933:SQL command not properly ended
update register
set customerid=right('0000'+rtrim(c.BRANCH_NO),4)+right(c.CUSTOM_NO,8)
from f_cust c
where register.iDCard is not null
and register.iDCard=c.CAupdate r
set customerid=
CASE len(rtrim(c.BRANCH_NO))
when 1 then '000'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
when 2 then '00'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
when 3 then '0'+rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
ELSE rtrim(c.BRANCH_NO)+right(c.CUSTOM_NO,8)
END
from register r,f_cust c
where r.iDCard is not null
and r.iDCard=c.CA可是我都报错:ORA-00933:SQL command not properly ended
解决方案 »
- 创建的pfile只有一行数据,求解释
- sql求助
- 有原先数据库中的几个dbf文件,如果恢复数据库 我是新手,对Oracle一点也不懂 急急急!!!!
- ORA-08103: object no longer exists 紧急求助
- pl/sql 连接oracle---ora-01031
- 关于oracle数据表的导入导出问题,急.
- 一个视图的建立求助(百分求助)
- Windows 应用程序能用 Ole DB Provider 连接 Oracle 吗?
- —*—*—*—我的問題,保證快速結賬—*—*—*—
- ORA-12500: TNS:listener failed to start a dedicated server process,救救我
- 简单sql语句?
- sql*plus中怎样执行有返回记录集的存储过程?
update 表名 set 列名 where (条件)
你用这个写法试试?
update register a
set a.customerid=right('0000'+rtrim(c.BRANCH_NO),4)+right(c.CUSTOM_NO,8)
where (select a.customerid from f_cust c
where register.iDCard=c.CA and register.iDCard is not null
update register a
set customerid=select lpad(branch_no,4,'0')||substr(custom_no,-1,8) from f_cust where a.CA=IDCard;