SQL> drop table t1 purge;
表已删除。
SQL> create table t1 as select *From emp;
表已创建。
SQL> alter table t1 add a varchar2(20);
表已更改。
SQL> select *From t1;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO A
---------- ---------- --------- ---------- -------------- ---------- ---------- ---------- --------------------
7369 SMITH CLERK 7902 17-12月-80 800 20
7499 ALLEN SALESMAN 7698 20-2月 -81 1600 300 30
7521 WARD SALESMAN 7698 22-2月 -81 1250 500 30
7566 JONES MANAGER 7839 02-4月 -81 2975 20
7654 MARTIN SALESMAN 7698 28-9月 -81 1250 1400 30
7698 BLAKE MANAGER 7839 01-5月 -81 2850 30
7782 CLARK MANAGER 7839 09-6月 -81 2450 10
7839 KING PRESIDENT 17-11月-81 5000 10
7844 TURNER SALESMAN 7698 08-9月 -81 1500 0 30
7900 JAMES CLERK 7698 03-12月-81 950 30
7902 FORD ANALYST 7566 03-12月-81 3000 20
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO A
---------- ---------- --------- ---------- -------------- ---------- ---------- ---------- --------------------
7934 MILLER CLERK 7782 23-1月 -82 1300 10
已选择12行。
SQL> update t1 set a= ('zjs' ||'20120101'||to_char(rownum, 'FM000000000')) ;
已更新12行。
SQL> select *From t1;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO A
---------- ---------- --------- ---------- -------------- ---------- ---------- ---------- --------------------
7369 SMITH CLERK 7902 17-12月-80 800 20 zjs20120101000000001
7499 ALLEN SALESMAN 7698 20-2月 -81 1600 300 30 zjs20120101000000002
7521 WARD SALESMAN 7698 22-2月 -81 1250 500 30 zjs20120101000000003
7566 JONES MANAGER 7839 02-4月 -81 2975 20 zjs20120101000000004
7654 MARTIN SALESMAN 7698 28-9月 -81 1250 1400 30 zjs20120101000000005
7698 BLAKE MANAGER 7839 01-5月 -81 2850 30 zjs20120101000000006
7782 CLARK MANAGER 7839 09-6月 -81 2450 10 zjs20120101000000007
7839 KING PRESIDENT 17-11月-81 5000 10 zjs20120101000000008
7844 TURNER SALESMAN 7698 08-9月 -81 1500 0 30 zjs20120101000000009
7900 JAMES CLERK 7698 03-12月-81 950 30 zjs20120101000000010
7902 FORD ANALYST 7566 03-12月-81 3000 20 zjs20120101000000011
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO A
---------- ---------- --------- ---------- -------------- ---------- ---------- ---------- --------------------
7934 MILLER CLERK 7782 23-1月 -82 1300 10 zjs20120101000000012
已选择12行。