规则如下:
依据这个规则、只有 3 种输出:大写、小写、首字母大写
测试如下:
sys@ORCL> select to_char(sysdate,'Month') from dual;
TO_CHAR(SYSDATE,'MONTH')
------------------------------------
June
sys@ORCL> select to_char(sysdate,'MOnth') from dual;
TO_CHAR(SYSDATE,'MONTH')
------------------------------------
JUNE
sys@ORCL> select to_char(sysdate,'month') from dual;
TO_CHAR(SYSDATE,'MONTH')
------------------------------------
june
下面做个测试、确认这个规则对函数索引的影响:
sys@ORCL> drop table t purge;
Table dropped.
sys@ORCL> create table t as select object_id,sysdate+rownum as create_date from dba_objects where rownum<=5000;
Table created.
sys@ORCL> analyze table t compute statistics;
Table analyzed.
sys@ORCL> set autot trace exp
sys@ORCL> select * from t