环境 : Windows 2003 Server + Oracle 9.2.0.7.0 -----------------------------------------------------------------------------------------------------------
C:\>sqlplus "test/test@wanglj"
SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 10月 13 06:31:53 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> create table my_orders
2 (
3 orderid varchar2(60) ,
4 orderdate date ,
5 customerid varchar2(60) ,
6 remark varchar2(255)
7 )
8 /
表已创建。
SQL> insert into my_orders(orderid , orderdate , customerid , remark )
2* values('2009010198123','17-NOV-2009','09821264','N/A')
SQL> /
values('2009010198123','17-NOV-2009','09821264','N/A')
*
ERROR 位于第 2 行:
ORA-01843: 无效的月份
SQL> alter session set nls_date_format='DD-MON-YYYY';
会话已更改。
SQL> insert into my_orders(orderid , orderdate , customerid , remark )
2 values('2009010198123','17-NOV-2009','09821264','N/A');
values('2009010198123','17-NOV-2009','09821264','N/A')
*
ERROR 位于第 2 行:
ORA-01843: 无效的月份
SQL>
SQL> alter session set nls_date_language=AMERICAN;
会话已更改。
SQL>
SQL> insert into my_orders(orderid , orderdate , customerid , remark )
2 values('2009010198123','17-NOV-2009','09821264','N/A');
已创建 1 行。
SQL> select count(*) from my_orders ;
COUNT(*)
----------
1
SQL>
-- the end ------------------------------------------------------------------------------------------------