SQL> insert into t_date values(null);

1 row inserted

SQL> commit;

Commit complete

SQL> select to_char(a,'yyyymmdd') from t_date;

TO_CHAR(A,'YYYYMMDD')
---------------------

SQL> select to_char(a,'yyyymmdd'),nvl(to_char(a,'yyyymmdd'),1) from t_date;

TO_CHAR(A,'YYYYMMDD') NVL(TO_CHAR(A,'YYYYMMDD'),1)
--------------------- ----------------------------
1

SQL> select to_char(a,'yyyymmdd'),nvl(a,1) from t_date;

select to_char(a,'yyyymmdd'),nvl(a,1) from t_date

ORA-00932: 数据类型不一致: 应为 DATE, 但却获得 NUMBER

SQL> select to_char(a,'yyyymmdd'),nvl(a,'1') from t_date;

select to_char(a,'yyyymmdd'),nvl(a,'1') from t_date

ORA-01840: 输入值对于日期格式不够长

ITPub博客

ora-00932与ora-01840

最新文章