oracle 查询两个表中字段，将这两个字段合成一个字符串

[luomingchu]

oracle 查询两个表中字段，将这两个字段合成一个字符串。

比如 A 表中 A1 字段
B 表中 B1 字段
我想查询出 A1:B1 的字符串插入到 C 表中 C1 字段

该如何实现？

[htl258_Tony]

没有关联的主键？

[htl258_Tony]

insert into C
select A1 || B1 from A,B where a.ID=B.ID

[xiequan2]

insert into c(c1) select a1||B1 from A join B on A.id=B.id

[htl258_Tony]

insert into C (c1)
  select A1 || B1 from A,B where a.ID=b.ID

[sdhdy]

oracle的||相当于SQL的+

[SQL77]

SELECT NEWID=IDENTITY(INT,1,1),* INTO #A FROM A 
SELECT NEWID=IDENTITY(INT,1,1),* INTO #B FROM B
INSERT C(COL) SELECT A1||B1 FROM #A  A JOIN #B B ON A.ID=B.ID

ORACLE里有IDENTITY吧

[SQL77]

SELECT [NEWID]=IDENTITY(INT,1,1),* INTO #A FROM A 
SELECT [NEWID]=IDENTITY(INT,1,1),* INTO #B FROM B
INSERT C(COL) SELECT A1||B1 FROM #A  A JOIN #B B ON A.[NEWID]=B.[NEWID]

[soft_wsx]

ORACELE字符串合并运算符为||
其实楼主哥哥应该在ORACLE上学问

[luomingchu]

自己想出来了，呵呵
Select concat(a.m,b.n)
FROM
( select parameter_value m from p_par_sysx Where parameter_name='site_for_nb_carton') a,
( select ':'||parameter_value n from p_par_sysx Where parameter_name='site_for_made_in') b

[xiequan2]

[Quote=引用 9 楼 luomingchu 的回复:]
自己想出来了，呵呵
Select concat(a.m,b.n)
FROM
( select parameter_value m from p_par_sysx Where parameter_name='site_for_nb_carton') a,
( select ':'||parameter_value n from p_par_sysx Where parameter_name='site_for_made_in') b
[/Quote] 恭喜

[luomingchu]

Update c_rou_part Set site_code_for_shipping_label =
(
Select a.m||':'||b.n
FROM
( select parameter_value m from p_par_sysx Where parameter_name='site_for_nb_carton') a,
( Select parameter_value n from p_par_sysx Where parameter_name='site_for_made_in') b
) Where part_no='97.01H34.301'

[SQL77]

[Quote=引用 11 楼 luomingchu 的回复:]
Update c_rou_part Set site_code_for_shipping_label =
(
Select a.m||':'||b.n
FROM
( select parameter_value m from p_par_sysx    Where parameter_name='site_for_nb_carton') a,
( Select parameter_value n from p_par_sysx  Where parameter_name='site_for_made_in') b
) Where part_no='97.01H34.301'
[/Quote]
不懂,连接没条件吗??呵呵