Advertisement
psi_mmobile

Untitled

Mar 24th, 2020
803
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 5.00 KB | None | 0 0
  1. UPDATE oc_poi_load_data
  2. SET TO_DATE = ADD_MONTHS(TO_DATE, 2000 * 12)
  3. WHERE TRIM(poi_short_name) IN ('EL3123','EL2179','SA2486','SA1507','SA2153','SA2154','SA2158','SA2180','SA2415','SA2423','SA2429','SA2440','SA2453','EL2158','EL2166','EL2200','EL9850','EL2179','EL2130','EL2146','CO3830','SA2496','EL2180','SA2470','SA2440','SA2158','EL2179','SA3526','CO2815','CO2816','CO2824','CO2834','CO2838','CO9800','CO9850','EL2035','EL2041','EL2050','EL2053','EL2077','EL2101','EL2132','EL2138','EL2139','EL2145','EL2154','CO3837','CO3838','EL3179','SA2496','EL4012','EL16143','SOT','SOT','SOT','EL15111','EL13057','EL13057','EL13057','EL16006','EL16111','SA15545','SOT','SA15476','SA17421','EL16133','EL15143','EL16076','SA16503','SA17446','SA16510','EL16116','EL16119','0003','SA17447','CO16910','SA17421','0003','0005','EL17130','EL17147','EL16153','EL17185','0003','0005','SA15768','SA15768','EL17155','0005','EL17155','EL17154','EL17159','EL17130','SA17400','SA15782','EL16131','7310','CO18941','0003','0003','EL17087','EL18092','SA19435','EL18092','SA19435','EL19022','CO19907','EL19167','EL19168','SA16474','CO19140','0005','CLARK EL','EL19056','SA17446','SA17421','SA16554','EL16137','0007CO','0007SA','0007EL','SA14524DEC','CO17931','EL17086','EL15143','EL15156','SA15476','EL16082','EL4012','EL15105','EL15059','EL15072','EL3073','EL3081','EL3084','EL3094','EL3104','EL3110','EL3119','EL3133','EL3147','EL3149','EL3161','SA3415','SA3417','SA3443','SA3453','SA3418','EL15037','SA14524','SA2504','SA15413','SA4420','EL4052','EL3218','EL0196','SA3455','SA2452','SA0510','SA1477','SA1576','SA2411','SA2412','SA2417','SA2421','SA2422','SA2441','SA2452','SA2454','EL2152','EL2216','EL2161','EL2196','EL2216','EL2217','EL2225','EL2228','EL2238','EL2816','EL5313','SA0407','SA0510','SA1417','SA1453','SA0427','SA0507','EL2140','EL2162','EL0174','EL0159','SA1418','SA1435','EL1102','SA1518','SA0484','EL1102','EL9225','SA0525','SA0549','SA0507','SA2493','SA4411','SA0404','SA2412','EL1122','EL0174','CO3821','CO3822','EL3067','CO3829','CO3818','CO3819','CO3828','CO3833','CO3834','CO3835','SA3481','CO3804','CO3805','CO3806','CO3807','CO3808','CO3810','CO3836','EL3025','EL3033','SA1533','EL3043','EL3044','EL3045','EL3048','EL3052','EL3063','EL3064','SA3468','SA3492','SA3499','SA3509','SA3510','SA3523','SA9520','CO1804','EL1047','CO2843','CO2846','CO8962','EL0022','EL1016','EL1046','EL1047','EL1104','EL1105','EL1181','EL2011','EL2014','EL2016','EL2088','EL2152','SA3511','SA4458','EL9030','SA3531','SA3532','SA3535','EL3187','CO3841','EL3190','EL3056','EL3507','SA3471','EL3197','CO3843','SA3558','EL3085','CO3825','EL3212','EL3181','EL3176','SA3507 ','EL3011','SA3570','EL4022','EL4025','EL3040','SA2417','EL3040','SA2568','SA3502','EL4033','EL4033','SA4451','EL3164','EL4042','0001','0002','EL3040','SA2417','0001','EL4025','CO3845','SA3565','SA3524','EL14143','EL4037','SA4440','EL4013','EL4035','SA4432','EL4025','EL4105','SA14508','EL14130','EL14132','SA14558','SA14501','SA4452','SA14534','SA4440','EL2140','SA14513','EL16164','EL15072','SA14598','SA15750','SA14524','SA16551','SA14548','SA15463','EL15141','EL15106','SA14404','EL15145','0001','SA15467','SA15423','EL15154','EL15085','EL15162','0001','SA15423','EL15009','EL17121','EL17122','EL17041','EL17017','EL17124','0001','0002','0001','0002','0004','SA17507','EL17024','EL17100','EL17017','0001','0004','0002','0008','EL17181','0006','CO17910','EL17176','EL17202','0008','0007 ','CO17922','EL17134','CO17938','EL17143','EL17094','EL17203','EL18011','EL18047','EL18072','EL17203','EL17217','EL17182','EL18039','CO18923','SA18415','SA18476','0001','0002','EL18020','EL18075','EL18091','EL16081','CO14875','CO19905','CO18936','SA18452','SA17489','EL17143','SA19443','CO18913','SA19465','EL19017','CO19935','SA18506','CO19921','EL19097','EL19049','EL20044','CO19910','SA19444','SA19458','EL19101','EL19107','EL20070','EL19062','0001','SA14598','0002','0004','0006','EL17152','CO17918','SA17507','EL18166','EL16145','EL17124','SA17480','EL17119','EL17120','EL17106','CO18912','CO17940','EL17910','EL18052','SA17517','EL18060','EL18032','CO19936','SA20403','CO19930','SA20700','SA20701','SA20702','SA20703','SA20704','SA20705','SA20706','SA20707','EL19077','CO20900','CO19901','EL19088','SA19452','SA19466','EL19109','EL20040','CO20905','SA20708','SA20709','SA20710','SA20711','SA20712','SA20713','SA20714','SA20715','SA19468','EL19096','EL19103','EL19075','EL19067','EL20069','EL19112','SA20716','SA20717','SA20718','SA20719','SA20720','A20721','SA20722','EL15009','SA15463','0008','EL16081','SA20723','SA20724','SA20725','SA20726','SA20727','SA20728','SA20729','SA20730','EL20018','SA20731','EL20062','SA20406','EL20064','SA19457','EL20074','EL20083','SA15458','EL15043','EL15083','CO17930','EL18040','EL18024','EL18047','EL18050','SA18449','EL18034','OPL002','OPL001','0007','EL18038','EL18072','EL18061','CO18949','EL18138','CO18950','EL18146','SA18554','EL19016','EL17169','EL19018','EL18141','EL18118','EL19050','SA19440','EL18080','CO19927','EL19060','CO19902','EL18076','SA19460','CO19906','EL18062')
  4. AND TO_DATE IS NOT NULL
  5. AND oc_poi_load_id = 202241;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement