插入语句
注意emp后面的column要和values后面的column一一对应
SQL> insert into emp(empno,ename) values(0001,'ORA');
1 row created.
SQL> commit;
Commit complete.
如果emp后面没有column,则默认的values后面要求插入所有column的数据
SQL>insert into emp values(0002,'ORACLE','MANAGER',0001,'01-01-2009',15000,5000,30)
SQL> commit;
Commit complete.
子查询用于插入数据
SQL> create table test as select * from emp where 1=2;
Table created.
SQL> insert into test select * from emp where empno in(7839,7566);
2 rows created.
更新数据
set后面是更新column如有多个column用“,”隔开,用where条件限定要跟新的行
SQL> update test set ename='ORA',job='manager' where empno=7934;
1 row updated.
SQL> commit;
Commit complete.
子查询用于跟新(关联跟新),更新column的值可以是子查询(返回必须是单行函数),跟新限定条件也可以是子查询
update test set ename=(select ename from emp where empno=7934) where job=(select job from emp where empno=7782);
删除数据
用where条件指定要删除的行
SQL> delete test where empno=2;
1 row deleted.
SQL> commit;
如果没有指定where条件,那么将删除整张表
SQL> delete test;
SQL> commit;
子查询用于删除
where条件后使用子查询指定要删除的行
SQL> delete test where job=(select job from emp where empno=7839);
2 rows deleted.
SQL> commit;
Commit complete.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20844861/viewspace-594633/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20844861/viewspace-594633/