Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>sqlplus
SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 3月 22 13:56:17 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

请输入用户名: scott/a123456

连接到:
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 EMP
2         (EMPNO NUMBER(4) NOT NULL,
3          ENAME VARCHAR2(10),
4          JOB VARCHAR2(9),
5          MGR NUMBER(4),
6          HIREDATE DATE,
7          SAL NUMBER(7, 2),
8          COMM NUMBER(7, 2),
9          DEPTNO NUMBER(2));

表已创建。

SQL> INSERT INTO EMP VALUES
2          (7521, 'WARD',   'SALESMAN', 7698,
3          TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30);
        TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30)
                *
ERROR 位于第 3 行:

ORA-01843: 无效的月份

SQL> alter session set nls_language=american ;

Session altered.

SQL> INSERT INTO EMP VALUES
2          (7521, 'WARD',   'SALESMAN', 7698,
3          TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30);

1 row created.

SQL> commit ;

Commit complete.

SQL>

本文来自http://hi.baidu.com/xcl119xcl/blog/item/f3d647017080cade277fb5bb.html