Oracle 创建多个表联合的视图

TABLE1表字段：NENAME , STYLE ,LAC

TABLE2表字段：NENAME , STYLE ,ENBID

TABLE3表字段：NENAME , STYLE ,SID,NID

 CREATE OR REPLACE VIEW VIEWBASESTATION AS 
 SELECТ NENAME , STYLE , 'lacci' AS STATIONTYPE , LAC AS BASESTATION from TABLE1 
 UNION 
 SELECТ NENAME , STYLE , 'enbid' AS STATIONTYPE , ENBID BASESTATION from TABLE2
 UNION 
 SELECТ NENAME , STYLE , 'bsid' AS STATIONTYPE , SID || ' ' || NID BASESTATION from TABLE3;

备注：|| 为字段拼接

执行后，视图字段： NENAME , STYLE ,STATIONTYPE,BASESTATION