Oracle中合并列和行

1:合并列  

Employees_Norway:

E_ID	E_Name
01	Hansen, Ola
02	Svendson, Tove
03	Svendson, Stephen
04	Pettersen, Kari

Employees_USA:

E_ID	E_Name
01	Turner, Sally
02	Kent, Clark
03	Svendson, Stephen
04	Scott, Stephen

SQL Union和SQL Union All

 

 

2：合并行

  a---------select   concat(aaa,bbb)   as   colc   from   table_name;   
  
  b---------select   aaa||bbb   as   colc   from   table_name;