Tạo view nhiều bảng trong Oracle Database

DROP VIEW user1.V_table1;

/* Formatted on 17/06/2013 09:02:28 (QP5 v5.163.1008.3004) */

CREATE OR REPLACE FORCE VIEW user1.V_table1

(

   SUB_ID,

   ORG_MOB_TYPE,

   MOB_TYPE,

   ISDN,

   IMSI,

   IN_ID,

   CEN_CODE,

   CREATE_DATETIME,

   SEGMENT_ID,

   ACTIVE_DATETIME,

   PRELOAD_AMOUNT,

   ACTIVE_AMOUNT

)

AS

   SELECT SUB_ID,

          ORG_MOB_TYPE,

          MOB_TYPE,

          ISDN,

          IMSI,

          IN_ID,

          CEN_CODE,

          CREATE_DATETIME,

          SEGMENT_ID,

          ACTIVE_DATETIME,

          PRELOAD_AMOUNT,

          ACTIVE_AMOUNT

     FROM user1.table1

   UNION ALL

   SELECT SUB_ID,

          ORG_MOB_TYPE,

          MOB_TYPE,

          ISDN,

          IMSI,

          IN_ID,

          CEN_CODE,

          CREATE_DATETIME,

          SEGMENT_ID,

          ACTIVE_DATETIME,

          PRELOAD_AMOUNT,

          ACTIVE_AMOUNT

     FROM user11.table1

   UNION ALL

   SELECT SUB_ID,

          ORG_MOB_TYPE,

          MOB_TYPE,

          ISDN,

          IMSI,

          IN_ID,

          CEN_CODE,

          CREATE_DATETIME,

          SEGMENT_ID,

          ACTIVE_DATETIME,

          PRELOAD_AMOUNT,

          ACTIVE_AMOUNT

     FROM user13.table1

   UNION ALL

   SELECT SUB_ID,

          ORG_MOB_TYPE,

          MOB_TYPE,

          ISDN,

          IMSI,

          IN_ID,

          CEN_CODE,

          CREATE_DATETIME,

          SEGMENT_ID,

          ACTIVE_DATETIME,

          PRELOAD_AMOUNT,

          ACTIVE_AMOUNT

     FROM user14.table1;

DROP PUBLIC SYNONYM V_table1;

CREATE OR REPLACE PUBLIC SYNONYM V_table1 FOR user1.V_table1;

KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH: 📧 Mail: binhoracle@gmail.com ☎️ Mobile: 0902912888 ⚡️ Skype: tranbinh48ca 👨 Facebook: https://www.facebook.com/BinhOracleMaster 👨 Inbox Messenger: https://m.me/101036604657441 (profile) 👨 Fanpage: https://www.facebook.com/tranvanbinh.vn 👨 Inbox Fanpage: https://m.me/tranvanbinh.vn 👨👩 Group FB: https://www.facebook.com/groups/OracleDBAVietNam 👨 Website: http://www.tranvanbinh.vn 👨 Blogger: https://tranvanbinhmaster.blogspot.com 🎬 Youtube: http://bit.ly/ytb_binhoraclemaster 👨 Tiktok: https://www.tiktok.com/@binhoraclemaster?lang=vi 👨 Linkin: https://www.linkedin.com/in/binhoracle 👨 Twitter: https://twitter.com/binhoracle 👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội #OracleTutorial #OracleDBA #OracleDatabaseAdministration #học oracle database #oca #ocp #oce #ocm