oracle简单查询问题！！！！

Question

将多行数据查询出来放到另外一张表的某个字段下。如图所示！

Answer 1

insert into T3(ID,DESCRIPTION)
values (select T2.ID,T2.DEPT||' '||T1.NAME||' '||T1.SALARY
from T1,T2
where T1.ID = T2.ID)
用连接符||将多个字段连接起来就可以了

Answer 2

SELECT T1.ID,T2.DPET||' '||T1.NAME||' '||T1.SALARY "DESCRIPTION"
FROM T1,T2
WHERE T1.ID=T2.ID

Answer 3

SELECT t1.id, dept||' '||name||' '||to_char(salary) as DESCRIPTION
FROM t1,t2
WHERE t1.id=t2.id本回答被提问者采纳

Answer 4

insert into tablename1(col1,col2)
values(select c1,c2 from tablename2 where ... )

Answer 5

select t1.id,t2.dept||t1.name||t1.salary
from t1,t2
where t1.id=t2.id