insert into mytable
select a.id,a.x1,b.x2,c.x3 from a,b,c where a.id=b.id(+) and a.id = c.id(+);
select a.id,a.x1,b.x2,c.x3 from a,b,c where a.id=b.id(+) and a.id = c.id(+);
解决方案 »
- oracle shutdown 报错
- 请帮个忙:关于判断数据的递增或者递减
- 为何我在Win2000Server上安装ORACLE9I的时候不能安装,点SETUP后一直没有反映
- SQL SERVER 2k &Oracle 数据交换问题
- 如何写SQL从一个表里,获取最近两个月的数据记录
- 请高手指点,为什么我的dbms_job执行不成功?
- sql检索文中子段相等判断问题,急盼解决!!!
- Oracle连接奇怪的问题
- 求教多表连接问题
- 急!oracle8i为什么装不了呢?
- 我需要重新建立一张表上的主键索引(就是索引正好建立在构成主键的几个字段上),应该如何写SQL??
- 在PB前台中有一SQL语句,update a set a.r = 1 ; 在commit发往数据库后台时怎样自动将此语句在后台的执行代码得到?在线等待。
我一开始就是这样做的!
---------- --------------------
103 kaifazhe
105 kaifazhe
107 kaifazhe
开发者 kaifazhe
101 kaifazheSQL> select * from a4;BBB CCC
---------- --------------------
22 bb
11 aa
33 cc
开 kai
发 fa
者 zhe
105 aaa
101 kaifazhe已选择8行。SQL> create table a6 (bbb varchar2(10),ccc1 varchar2(10),ccc2 varchar2(10));表已创建。SQL> insert into a6 select a2.bbb,a2.ccc,a4.ccc from a2,a4 where a2.bbb=a4.bbb(+);已创建5行。SQL> select * from a6;BBB CCC1 CCC2
---------- ---------- ----------
101 kaifazhe kaifazhe
103 kaifazhe
105 kaifazhe aaa
107 kaifazhe
开发者 kaifazhe我试着可以啊
SQL> select * from a;ID X1
------ --------------------
001 test
002 test1Elapsed: 00:00:00.00
SQL> select * from b;ID X2
------ --------------------
001 *****
002 aaaElapsed: 00:00:00.10
SQL> select * from c;ID X3
------ --------------------
002 ****Elapsed: 00:00:00.10SQL> select a.id as id,a.x1 as x1,b.x2 as x2,c.x3 as x3 from a,b,c where a.id=b.
id(+) and a.id=c.id(+);ID X1 X2 X3
------ -------------------- -------------------- --------------------
001 test *****
002 test1 aaa ****Elapsed: 00:00:00.30SQL> delete from c ;1 row deleted.Elapsed: 00:00:00.20
SQL> commit;Commit complete.Elapsed: 00:00:00.30
SQL> select a.id as id,a.x1 as x1,b.x2 as x2,c.x3 as x3 from a,b,c where a.id=b.
id(+) and a.id=c.id(+);ID X1 X2 X3
------ -------------------- -------------------- --------------------
001 test *****
002 test1 aaaElapsed: 00:00:00.40