修改一下语句
INSERT INTO PLSQL101_PERSON VALUES
('ca','charlene','atlas',to_date('20020201','yyyymmdd');
INSERT INTO PLSQL101_PERSON VALUES
('ca','charlene','atlas',to_date('20020201','yyyymmdd');
----------
01-1月 -03SQL> alter session set nls_date_format='yyyy-mm-dd';会话已更改。SQL> insert into tb33 values('01-1月-03');
insert into tb33 values('01-1月-03')
*
ERROR 位于第1行:
ORA-01861: 文字与格式字符串不匹配
SQL> insert into tb33 values('2003-01-01');已创建 1 行。SQL> select * from tb33;BB
----------
2003-01-01
2003-01-01SQL>