SQL合集

sql小数to_char后个位0不显示问题

https://www.cnblogs.com/wangshuaicxy/p/13230083.html

select to_char(0.2, 'fm999990.99999') from dual;     /*显示为   0.2 */
select to_char(0.2) from dual;　　　　　　　　　　/*显示为   .2 */

oracle除法保留4位小数

https://blog.csdn.net/ydlmlh/article/details/84153035

select round(100/3,4) from dual

Oracle&SQLServer中实现跨库查询 Database Link

https://www.cnblogs.com/spring_wang/p/8493420.html
Oracle创建Database Link
https://www.cnblogs.com/mingforyou/p/8276372.html
https://www.cnblogs.com/zhm1985/p/12106306.html