SQL> SQL> with tablea as 2 ( 3 select 'aaa' a,'bbb' b from dual union all 4 select 'bbb' a,'aaa' b from dual 5 ) 6 select wm_concat(a||'-'||b) from tablea 7 ;WM_CONCAT(A||'-'||B) -------------------------------------------------------------------------------- aaa-bbb,bbb-aaaSQL>
SQL>
SQL> with tablea as
2 (
3 select 'aaa' a,'bbb' b from dual union all
4 select 'bbb' a,'aaa' b from dual
5 )
6 select wm_concat(a||'-'||b) from tablea
7 ;WM_CONCAT(A||'-'||B)
--------------------------------------------------------------------------------
aaa-bbb,bbb-aaaSQL>
SELECT uname.*,message.*,(select * from admin) FROM message INNER JOIN uname ON uname.uid = message.lridselect sum(int你的字段)into 新表 from 旧表