SQL> select deptno,dname,loc from dept order by deptno asc;
DEPTNO DNAME
LOC
---------- -------------- -------------
10
ACCOUNTING NEW YORK
12
ii
dalian
13 boby
time
14 bill
forrada
20 RESEARCH DALLAS
30
SALES
CHICAGO
40
OPERATIONS BOSTON
50
buid
sys
60 order
har bin
70
jame
tarm
80
lob
beijing
DEPTNO
DNAME
LOC
---------- -------------- -------------
90
ok
xin jiang
已选择12行。
SQL> insert into dept values(11,'ok','hao');
已创建 1 行。
SQL> commit;
提交完成。
SQL> select deptno,dname,loc from dept order by deptno asc;
DEPTNO DNAME
LOC
---------- -------------- -------------
10ACCOUNTING NEW YORK
11ok
hao
12 ii
dalian
13 boby
time
14 bill
forrada
20 RESEARCH
DALLAS
30 SALES
CHICAGO
40 OPERATIONS BOSTON
50 buid
sys
60order
har bin
70jame
tarm
DEPTNODNAME
LOC
---------- -------------- -------------
80lob
beijing
90ok
xin jiang
|