Microsoft Windows 2000 [Version 5.00.2195]
(C) 版权所有 1985-2000 Microsoft Corp.
C:\>set nls_lang=american_america.we8iso8859p1
C:\>sqlplus scott/tiger@ora9i
SQL*Plus: Release 9.2.0.1.0 - Production on Wed Feb 11 17:06:58 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
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> select hiredate from emp where rownum<2;
HIREDATE
---------
17-DEC-80
SQL> desc emp
Name Null? Type
----------------------------------------- -------- ---------------------------
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)
SQL> edit
Wrote file afiedt.buf
1 insert into emp
2 (empno,ename,hiredate)
3 values
4* (9999,'test','29-MAR-99')
SQL> /
1 row created.
SQL> select ename,hiredate from emp;
ENAME HIREDATE
---------- ---------
SMITH 17-DEC-80
ALLEN 20-FEB-81
WARD 22-FEB-81
JONES 02-APR-81
MARTIN 28-SEP-81
BLAKE 01-MAY-81
CLARK 09-JUN-81
SCOTT 19-APR-87
KING 17-NOV-81
TURNER 08-SEP-81
ADAMS 23-MAY-87
ENAME HIREDATE
---------- ---------
JAMES 03-DEC-81
FORD 03-DEC-81
MILLER 23-JAN-82
test 29-MAR-99
15 rows selected.
SQL>