insert into C select A1 || B1 from A,B where a.ID=B.ID
insert into c(c1) select a1||B1 from A join B on A.id=B.id
insert into C (c1) select A1 || B1 from A,B where a.ID=b.ID
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吧
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]
ORACELE字符串合并运算符为|| 其实楼主哥哥应该在ORACLE上学问
自己想出来了,呵呵 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
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'
select A1 || B1 from A,B where a.ID=B.ID
select A1 || B1 from A,B where a.ID=b.ID
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吧
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]
其实楼主哥哥应该在ORACLE上学问
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
(
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'