当前位置:网站首页>表达式必须具有与对应表达式相同的数据类型
表达式必须具有与对应表达式相同的数据类型
2022-08-11 08:30:00 【hhkun0120】
SELECT c.grant_class,
a.bank_code,
a.bank_acc_no AS acc_No,
a.acc_cust_name,
c.ahr_id_no AS id_no,
c.ahr_addr AS address,
c.ahr_tel,
c.ahr_rt_phr_or_ipsn,
to_char(a.finishing_date, 'yyyy-MM-dd') finishing_date,
'' term_date,
'' bank_acc_type,
b.mtn_biz_no cntr_no
FROM A
WHERE a.mtn_id = b.mtn_id
AND b.mtn_id = c.mtn_id
AND b.proc_stat = '4'
UNION
SELECT c.grant_class,
a.bank_code,
a.bank_acc_no AS acc_No,
a.acc_cust_name,
c.ahr_id_no AS id_no,
c.ahr_addr AS address,
c.ahr_tel,
c.ahr_rt_phr_or_ipsn,
to_char(a.finishing_date, 'yyyy-MM-dd')finishing_date,
'' term_date,
'' bank_acc_type,
d.cntr_no
FROM mtn_gen_info a,
mtn_alt_cntr b,
GRANT_TRAN_APPL c,
GRANT_TRANLST d
WHERE a.mtn_id = b.mtn_id
AND b.mtn_id = c.mtn_id
AND c.mtn_id = d.mtn_id
AND b.proc_stat = '4'
UNION
SELECT grant_class,
bank_code,
bankacc_no AS acc_No,
bankacc_name,
ahr_id_no AS id_no,
ahr_addr AS address,
ahr_tel,
ahr_rt_phr_or_ipsn,
to_char(valid_date, 'yyyy-MM-dd'),
'' term_date,
bank_acc_type,
cntr_no
FROM B
UNION
SELECT 'E' grant_class,
bank_code,
bank_acc_no AS acc_No,
acc_cust_name bankacc_name,
'' AS id_no,
'' AS address,
'' ahr_tel,
'' ahr_rt_phr_or_ipsn,
'' valid_date,
'' term_date,
'' bank_acc_type,
cntr_no
FROM E
上述SQL是优化之后的,问题出在下面,之前是a.finishing_date是Date型,下面的'' 是string型,用to_char转换后就可以了。
to_char(a.finishing_date, 'yyyy-MM-dd') finishing_date,
边栏推荐
猜你喜欢
Active users of mobile banking grew rapidly in June, hitting a half-year high
记录一些遇见的bug——Lombok和Mapstruct的冲突导致,A component required a bean of type ‘com.XXX.controller.converter.
设置Vagrant创建的虚拟机名称和内存
向日葵安装教程--向日葵远程桌面控制
机器学习(一)数据的预处理
基于微信小程序的租房小程序
2022年值得关注的NFT发展趋势
FPGA 20个例程篇:11.USB2.0接收并回复CRC16位校验
8、Mip-NeRF
C Primer Plus(6) 中文版 第1章 初识C语言 1.7 使用C语言的7个步骤
随机推荐
leetcode: 69. Square root of x
Mysql JSON对象和JSON数组查询
Kotlin算法入门求回文数算法优化一
机器学习(一)数据的预处理
Project 1 - PM2.5 Forecast
golang 字符串操作
Kotlin算法入门兔子数量优化及拓展
jenkins简单使用
excel 透视表 值显示内容 不显示计数
Active users of mobile banking grew rapidly in June, hitting a half-year high
oracle数据库中列转行,列会有变化
如何通过 IDEA 数据库管理工具连接 TDengine?
Initial use of IDEA
Kali penetration test environment set up
程序员是一碗青春饭吗?
机器学习(二)线性回归
【Day_13 0509】▲跳石板
For the first time, I suspect that there is a bug in selenium4 because the iframe element is not found?
Do you know the basic process and use case design method of interface testing?
@RequiredArgsConstructor注解