oracle默认将字段转成了大写存着,查询的字段不加双引号默认转为大写去查询
使用双引号将区分大小写
select sysdate from dual;等同于select "SYSDATE" from dual;
select "sysdate" from dual;等同于select "sysdate" from dual;
oracle默认将字段转成了大写存着,查询的字段不加双引号默认转为大写去查询
使用双引号将区分大小写
select sysdate from dual;等同于select "SYSDATE" from dual;
select "sysdate" from dual;等同于select "sysdate" from dual;