如有两个表 T1, T2T1
custom sex age country
Jack m 21 USA
Tom m 24 USA
May w 24 CHS
KAKA m 40 JAP
T2
Name age company
Jack 21 HP
Tom 24 IBM
MAy 24 lenovo
如何把表T2的内容追加到表T1T1
custom sex age country company
Jack m 21 USA HP
Tom m 24 USA ibm
May w 24 CHS lenovo
YAKA m 40 JAP
custom sex age country
Jack m 21 USA
Tom m 24 USA
May w 24 CHS
KAKA m 40 JAP
T2
Name age company
Jack 21 HP
Tom 24 IBM
MAy 24 lenovo
如何把表T2的内容追加到表T1T1
custom sex age country company
Jack m 21 USA HP
Tom m 24 USA ibm
May w 24 CHS lenovo
YAKA m 40 JAP
解决方案 »
- 《影响SQL执行效率的情况》第二条如何理解?
- 急急急!!!Oracle存储过程问题。各仁兄前来解决
- 如何在9i的Oracle Management Server中添加10g的数据库??
- orcale数据库数据恢复问题,dbf;ora;log;ctl文件都有怎么恢复数据(急!急!急!急!)
- [点击给分]oracle的初始化参数,如NLS_DATE_FORMAT在哪里设置?
- 动态调用问题! ̄! ̄
- 做java直接转Oracle做DBA 还是先做ETL再做DBA
- 大文件在数据库里面放地址路径,文件放在外边,那么oracle要lob字段干什么,请解惑
- 请问blob类型的数据怎么相加呢?
- nls_date_format问题
- Oracle 字段不为空 时候 取值问题
- 初学者
(select company from t1,t2 where t1.name=t2.name);
(select t2.company from t1,t2 where t1.name=t2.name);
select custom,sex,t1.age,country,company
from t1,t2
where t1.custom=t2.name(+);
select a.custom,a.sex,a.age,a.country,b.company
from t1 a left join on a.name=b.name
using t2
on (t1.custom = t2.name)
when matched then
update t1.company = t2.company
/
SELECT T1.custom T1.sex T1.age T1.country T2.company
FROM T1,T2
WHERE t1.custom=t2.name(+);