日期:2014-05-17 浏览次数:20778 次
u1@EMREP> create table dept(dept_id number(6) primary key,dept_name varchar2(20) not null);
Table created.
u1@EMREP> insert into dept values(0,'IT');
1 row created.
u1@EMREP> insert into dept values(1,'FINACIAL');
1 row created.
u1@EMREP> commit;
Commit complete.
u1@EMREP> select * from dept;
DEPT_ID DEPT_NAME
---------- --------------------
0 IT
1 FINACIAL