select * from emp where last_name = ‘King‘ where last_name = ‘KING‘ --两次查询的结果不同 selelct * from emp where date = ‘20-12-18‘ where date = ‘2018-12-20‘ --语句报错 格式错误
alter session set NLS_DATE_FORMAT = ‘YYYY-MM-DD‘;
between 1000 and 2000; --可以查询到结果 between 2000 and 1000; --无法查询到结果
原文：https://www.cnblogs.com/keenoooo/p/10060944.html
