生成ビューDDL群サンプル

-- DROP VIEW ( V0002 )
DROP VIEW IF EXISTS V0002 CASCADE
;

-- CREATE VIEW ( V0002 )
CREATE VIEW V0002 AS
select t1.ORDER_NO AS ORDER_NO,t1.USER_ID AS USER_ID,m5.USER_NAME AS USER_NAME,t2.COL001 AS COL001,t2.COL002 AS COL002,t2.COL003 AS COL003,t2.COL004 AS COL004,t2.COL005 AS COL005,t2.COL006 AS COL006,t2.COL007 AS COL007,t2.COL008 AS COL008,t2.COL009 AS COL009,t2.COL010 AS COL010,t2.COL011 AS COL011,t2.COL012 AS COL012,t2.COL013 AS COL013,t2.COL014 AS COL014,t2.COL015 AS COL015,t2.COL016 AS COL016,t2.COL017 AS COL017,t2.COL018 AS COL018,t2.COL019 AS COL019,t2.COL020 AS COL020,t2.COL021 AS COL021,t2.COL022 AS COL022,t2.COL023 AS COL023,t2.COL024 AS COL024,t2.COL025 AS COL025,t2.COL026 AS COL026,t2.COL027 AS COL027,t2.COL028 AS COL028,t2.COL029 AS COL029,t2.COL030 AS COL030,t2.COL031 AS COL031,t2.COL032 AS COL032,t2.COL033 AS COL033,t2.COL034 AS COL034,t2.COL035 AS COL035,t2.COL036 AS COL036,t2.COL037 AS COL037,t2.COL038 AS COL038,t2.COL039 AS COL039,t2.COL040 AS COL040,t2.COL041 AS COL041,t2.COL042 AS COL042,t2.COL043 AS COL043,t2.COL044 AS COL044,t2.COL045 AS COL045,t2.COL046 AS COL046,t2.COL047 AS COL047,t2.COL048 AS COL048,t2.COL049 AS COL049,t2.COL050 AS COL050,t2.COL051 AS COL051,t2.COL052 AS COL052,t2.COL053 AS COL053,t2.COL054 AS COL054,t2.COL055 AS COL055,t2.COL056 AS COL056,t2.COL057 AS COL057,t2.COL058 AS COL058,t2.COL059 AS COL059,t2.COL060 AS COL060 from ((sampledb.t0001 t1 join sampledb.t0003 t2 on(t1.ORDER_NO = t2.ORDER_NO)) left join sampledb.m0005 m5 on(t1.USER_ID = m5.USER_ID))
;