![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Ebay
乐桐青
VS--c#-mssqlserver
Eclise-java-oracle&mysql
PyCharm-python-mysql&oracle
展开
-
官方文档
https://developer.amazonservices.com https://developer.ebay.com https://developer.stamps.com/developer/downloads https://sso.dhl-usa.com/sso/login_main.asp https://xmlportal.dhl.com/login https://www.ups.com/upsdeveloperkit https://redis.io https://w原创 2020-06-29 12:06:25 · 152 阅读 · 0 评论 -
REGEXP_SUBSTR +listagg结合子查询 高效获取优先级别最高的价格
昨天推敲出了一段值得记录的代码.可以解决oracle子查询 不能order by 去第一个的问题.对于初学者知识点较多.select nvl(REGEXP_SUBSTR((select listagg(to_char(sg.CUSTOM_COST,'fm9999999990.00'), ',') within GROUP(ORDER BY s.PRICE_PRIORITY desc) from store_goods sg...原创 2020-05-29 11:40:54 · 411 阅读 · 0 评论