第一个:select max(convert(int,TargetCode)) from tbTargetInfo注:报错信息为“int标识符无效”。TargetCode类型为VARCHAR2(4)
第二个 select * from
(select * from tbTargetInfo where TargetCode = '0001') as A
left join
(select ManageDeptCode,ManageDeptName as ManageDeptNameC from tbManageDept) as B
on A.AuditDeptCode = B.ManageDeptCode注:报错信息为“sql命令未正确结束”
TargetCode类型为VARCHAR2(4)
A表AuditDeptCode 和B表ManageDeptCode 的类型均为VARCHAR2(4)
第二个 select * from
(select * from tbTargetInfo where TargetCode = '0001') as A
left join
(select ManageDeptCode,ManageDeptName as ManageDeptNameC from tbManageDept) as B
on A.AuditDeptCode = B.ManageDeptCode注:报错信息为“sql命令未正确结束”
TargetCode类型为VARCHAR2(4)
A表AuditDeptCode 和B表ManageDeptCode 的类型均为VARCHAR2(4)
解决方案 »
- 求助,使用IBM Initiate WorkBench里的cloverETL配置时,无论是数据库导入到EXCEL还是EXCEL导入数据库,中文都会出现乱码
- 这个sql哪里错啊?
- 表记录拼凑问题
- 关于ORALCE DATA GUARD的一些疑问
- 请教, 不知可否用一条SQL语句实现,请高手赐教,不胜感激!
- 关于Oracle SQL速度优化!急!谢谢!!
- OracleOraDb10g_home1TNSListener 服务问题?
- 百分:关于plsql 语言中触发器的声明部分中变量生命周期的讨论
- 请教三个表之间关联的Update问题!急!
- regexp_like 判断是否是含有某个字符串
- 四个表关联的触发器
- jobs增加任务的日期添加报错
select max(to_number(TargetCode)) from tbTargetInfo
第二个
select *
from (select * from tbTargetInfo where TargetCode = '0001') A
left join (select ManageDeptCode, ManageDeptName as ManageDeptNameC
from tbManageDept) B on A.AuditDeptCode = B.ManageDeptCode
(select * from tbTargetInfo where TargetCode = '0001') A
left join
(select ManageDeptCode,ManageDeptName as ManageDeptNameC from tbManageDept) B
on A.AuditDeptCode = B.ManageDeptCode;
--1、oracle中转换类型有专门的函数 常用的有
to_char --转成字符串
to_mumber --转成数字
to_date --转成日期--你这个用 to_number--2、oracle里面和sqlserver里面的语法有点区别,在给子查询起别名的时候不能加 AS
--你写的sql,在子查询里后面 把AS 去掉,sqlserver也不会报错
--这样oracle和sqlserver就可以通用了select * from
(select * from tbTargetInfo where TargetCode = '0001') A
left join
(select ManageDeptCode,ManageDeptName as ManageDeptNameC from tbManageDept) B
on A.AuditDeptCode = B.ManageDeptCode
二 as 不能给表起别名