CREATE OR REPLACE VIEW V_Dic AS 
-- 民族
SELECT 1 Id, 0 Version, 'MZ' Type, '01' Code, '汉族' Name, 'HZ' Short_Name, 1 Flag, '汉族' Memo FROM DUAL UNION 
SELECT 2 Id, 0 Version, 'MZ' Type, '02' Code, '蒙古族' Name, 'MGZ' Short_Name, 1 Flag, '蒙古族' Memo FROM DUAL UNION 
SELECT 3 Id, 0 Version, 'MZ' Type, '03' Code, '回族' Name, 'HZ' Short_Name, 1 Flag, '回族' Memo FROM DUAL UNION 
SELECT 4 Id, 0 Version, 'MZ' Type, '04' Code, '藏族' Name, 'ZZ' Short_Name, 1 Flag, '藏族' Memo FROM DUAL UNION 
SELECT 5 Id, 0 Version, 'MZ' Type, '05' Code, '维吾尔族' Name, 'WWEZ' Short_Name, 1 Flag, '维吾尔族' Memo FROM DUAL UNION 
SELECT 6 Id, 0 Version, 'MZ' Type, '06' Code, '苗族' Name, 'MZ' Short_Name, 1 Flag, '苗族' Memo FROM DUAL UNION 
SELECT 7 Id, 0 Version, 'MZ' Type, '07' Code, '彝族' Name, 'YZ' Short_Name, 1 Flag, '彝族' Memo FROM DUAL UNION 
SELECT 8 Id, 0 Version, 'MZ' Type, '08' Code, '壮族' Name, 'ZZ' Short_Name, 1 Flag, '壮族' Memo FROM DUAL UNION 
SELECT 9 Id, 0 Version, 'MZ' Type, '09' Code, '布依族' Name, 'BYZ' Short_Name, 1 Flag, '布依族' Memo FROM DUAL UNION 
SELECT 10 Id, 0 Version, 'MZ' Type, '10' Code, '朝鲜族' Name, 'CXZ' Short_Name, 1 Flag, '朝鲜族' Memo FROM DUAL UNION 
SELECT 11 Id, 0 Version, 'MZ' Type, '11' Code, '满族' Name, 'MZ' Short_Name, 1 Flag, '满族' Memo FROM DUAL UNION 
SELECT 12 Id, 0 Version, 'MZ' Type, '12' Code, '侗族' Name, 'DZ' Short_Name, 1 Flag, '侗族' Memo FROM DUAL UNION 
SELECT 13 Id, 0 Version, 'MZ' Type, '13' Code, '瑶族' Name, 'YZ' Short_Name, 1 Flag, '瑶族' Memo FROM DUAL UNION 
SELECT 14 Id, 0 Version, 'MZ' Type, '14' Code, '白族' Name, 'BZ' Short_Name, 1 Flag, '白族' Memo FROM DUAL UNION 
SELECT 15 Id, 0 Version, 'MZ' Type, '15' Code, '土家族' Name, 'TJZ' Short_Name, 1 Flag, '土家族' Memo FROM DUAL UNION 
SELECT 16 Id, 0 Version, 'MZ' Type, '16' Code, '哈尼族' Name, 'HNZ' Short_Name, 1 Flag, '哈尼族' Memo FROM DUAL UNION 
SELECT 17 Id, 0 Version, 'MZ' Type, '17' Code, '哈萨克族' Name, 'HSKZ' Short_Name, 1 Flag, '哈萨克族' Memo FROM DUAL UNION 
SELECT 18 Id, 0 Version, 'MZ' Type, '18' Code, '傣族' Name, 'DZ' Short_Name, 1 Flag, '傣族' Memo FROM DUAL UNION 
SELECT 19 Id, 0 Version, 'MZ' Type, '19' Code, '黎族' Name, 'LZ' Short_Name, 1 Flag, '黎族' Memo FROM DUAL UNION 
SELECT 20 Id, 0 Version, 'MZ' Type, '20' Code, '傈僳族' Name, 'LSZ' Short_Name, 1 Flag, '傈僳族' Memo FROM DUAL UNION 
SELECT 21 Id, 0 Version, 'MZ' Type, '21' Code, '佤族' Name, 'WZ' Short_Name, 1 Flag, '佤族' Memo FROM DUAL UNION 
SELECT 22 Id, 0 Version, 'MZ' Type, '22' Code, '畲族' Name, 'SZ' Short_Name, 1 Flag, '畲族' Memo FROM DUAL UNION 
SELECT 23 Id, 0 Version, 'MZ' Type, '23' Code, '高山族' Name, 'GSZ' Short_Name, 1 Flag, '高山族' Memo FROM DUAL UNION 
SELECT 24 Id, 0 Version, 'MZ' Type, '24' Code, '拉祜族' Name, 'LHZ' Short_Name, 1 Flag, '拉祜族' Memo FROM DUAL UNION 
SELECT 25 Id, 0 Version, 'MZ' Type, '25' Code, '水族' Name, 'SZ' Short_Name, 1 Flag, '水族' Memo FROM DUAL UNION 
SELECT 26 Id, 0 Version, 'MZ' Type, '26' Code, '东乡族' Name, 'DXZ' Short_Name, 1 Flag, '东乡族' Memo FROM DUAL UNION 
SELECT 27 Id, 0 Version, 'MZ' Type, '27' Code, '纳西族' Name, 'NXZ' Short_Name, 1 Flag, '纳西族' Memo FROM DUAL UNION 
SELECT 28 Id, 0 Version, 'MZ' Type, '28' Code, '景颇族' Name, 'JPZ' Short_Name, 1 Flag, '景颇族' Memo FROM DUAL UNION 
SELECT 29 Id, 0 Version, 'MZ' Type, '29' Code, '柯尔克孜族' Name, 'KEKZZ' Short_Name, 1 Flag, '柯尔克孜族' Memo FROM DUAL UNION 
SELECT 30 Id, 0 Version, 'MZ' Type, '30' Code, '土族' Name, 'TZ' Short_Name, 1 Flag, '土族' Memo FROM DUAL UNION 
SELECT 31 Id, 0 Version, 'MZ' Type, '31' Code, '达斡尔族' Name, 'DWEZ' Short_Name, 1 Flag, '达斡尔族' Memo FROM DUAL UNION 
SELECT 32 Id, 0 Version, 'MZ' Type, '32' Code, '仫佬族' Name, 'MLZ' Short_Name, 1 Flag, '仫佬族' Memo FROM DUAL UNION 
SELECT 33 Id, 0 Version, 'MZ' Type, '33' Code, '羌族' Name, 'QZ' Short_Name, 1 Flag, '羌族' Memo FROM DUAL UNION 
SELECT 34 Id, 0 Version, 'MZ' Type, '34' Code, '布朗族' Name, 'BLZ' Short_Name, 1 Flag, '布朗族' Memo FROM DUAL UNION 
SELECT 35 Id, 0 Version, 'MZ' Type, '35' Code, '撒拉族' Name, 'SLZ' Short_Name, 1 Flag, '撒拉族' Memo FROM DUAL U