更新t_ware 去除空格

UPDATE T_WARE
SET
  barcode = TRIM(barcode),
  wareabc = TRIM(wareabc),
  warename = TRIM(warename),
  waregeneralname = TRIM(waregeneralname),
  warespec = TRIM(warespec),
  factoryid = TRIM(factoryid),
  warekind = TRIM(warekind),
  wareunit = TRIM(wareunit),
  waremark = TRIM(waremark),
  maxqty = TRIM(maxqty),
  midqty = TRIM(midqty),
  minunit = TRIM(minunit),
  minqty = TRIM(minqty),
  warningdays = TRIM(warningdays),
  saletax = TRIM(saletax),
  inittime = TRIM(inittime),
  lastmodify = TRIM(lastmodify),
  lasttime = TRIM(lasttime),
  stamp = TRIM(stamp),
  pile = TRIM(pile),
  advsaleprice = TRIM(advsaleprice),
  minbarcode = TRIM(minbarcode),
  trademark = TRIM(trademark),
  store_req = TRIM(store_req),
  extno = TRIM(extno),
  isinsurance = TRIM(isinsurance),
  insuranceno = TRIM(insuranceno),
  insurancename = TRIM(insurancename),
  lastpurprice = TRIM(lastpurprice),
  lastsetpurprice1 = TRIM(lastsetpurprice1),
  lastsetpurprice2 = TRIM(lastsetpurprice2),
  lastvencusno = TRIM(lastvencusno),
  lastsaleprice = TRIM(lastsaleprice),
  warecode = TRIM(warecode),
  purtax = TRIM(purtax),
  scan_flag = TRIM(scan_flag),
  notes = TRIM(notes),
  leastprice = TRIM(leastprice),
  buyer = TRIM(buyer),
  specialflag = TRIM(specialflag),
  inituser = TRIM(inituser),
  firstaccdate = TRIM(firstaccdate),
  lastaccdate = TRIM(lastaccdate),
  areacode = TRIM(areacode),
  status = TRIM(status),
  disttype = TRIM(disttype),
  purstatus = TRIM(purstatus),
  salestatus = TRIM(salestatus),
  leastsaleprice = TRIM(leastsaleprice),
  maxwhlprice = TRIM(maxwhlprice),
  maxsaleprice = TRIM(maxsaleprice),
  voidreason = TRIM(voidreason),
  data_src = TRIM(data_src),
  voiduser = TRIM(voiduser),
  voidtime = TRIM(voidtime),
  max_descode = TRIM(max_descode),
  mid_descode = TRIM(mid_descode),
  min_descode = TRIM(min_descode),
  purdate = TRIM(purdate),
  ware_type = TRIM(ware_type),
  distflag = TRIM(distflag),
  lastwhlprice = TRIM(lastwhlprice),
  bandcode = TRIM(bandcode),
  factoryname = TRIM(factoryname),
  parityware = TRIM(parityware),
  parityware_warecode = TRIM(parityware_warecode),
  leastpurprice = TRIM(leastpurprice),
  isreturn = TRIM(isreturn),
  wmark = TRIM(wmark),
  isbatmode = TRIM(isbatmode),
  warefollowflag = TRIM(warefollowflag),
  warefollowday = TRIM(warefollowday),
  waretarget = TRIM(waretarget),
  invaliddays = TRIM(invaliddays),
  twocard_flag = TRIM(twocard_flag),
  fileno = TRIM(fileno),
  ispsstatus = TRIM(ispsstatus),
  pwarecode = TRIM(pwarecode),
  contentspec = TRIM(contentspec),
  minoutqty = TRIM(minoutqty),
  is_yaolian = TRIM(is_yaolian),
  listing_holder = TRIM(listing_holder),
  hold_valid_date = TRIM(hold_valid_date),
  areaname = TRIM(areaname),
  warename_bak = TRIM(warename_bak),
  waregeneralname_bak = TRIM(waregeneralname_bak),
  comp_warestatus = TRIM(comp_warestatus),
  busi_trackdays = TRIM(busi_trackdays),
  lastsubitemid = TRIM(lastsubitemid),
  keyware_flag = TRIM(keyware_flag),
  mid_wareunit = TRIM(mid_wareunit),
  max_wareunit = TRIM(max_wareunit),
  mid_barcode = TRIM(mid_barcode),
  max_barcode = TRIM(max_barcode),
  min_lastsaleprice = TRIM(min_lastsaleprice),
  min_advsaleprice = TRIM(min_advsaleprice),
  memadvsaleprice = TRIM(memadvsaleprice),
  min_memadvsaleprice = TRIM(min_memadvsaleprice),
  min_stock = TRIM(min_stock),
  max_stock = TRIM(max_stock),
  safe_stock = TRIM(safe_stock),
  temperature = TRIM(temperature),
  lastownerid = TRIM(lastownerid),
  scan_len = TRIM(scan_len),
  tags = TRIM(tags),
  lastdistprice = TRIM(lastdistprice),
  if_season = TRIM(if_season),
  begdate_season = TRIM(begdate_season),
  enddate_season = TRIM(enddate_season),
  wms_putfreq = TRIM(wms_putfreq),
  wms_mixmakeno = TRIM(wms_mixmakeno),
  parent_classcode = TRIM(parent_classcode),
  child_classcode = TRIM(child_classcode),
  if_sealtype = TRIM(if_sealtype),
  minbulkstore = TRIM(minbulkstore),
  if_autoreplen = TRIM(if_autoreplen),
  udi_flag = TRIM(udi_flag),
  scan_type = TRIM(scan_type),
  lastmemprice = TRIM(lastmemprice),
  regfer = TRIM(regfer),
  imported_flag = TRIM(imported_flag);

				

					
				
				

					
				
				

					
				
				

					
				
			

去除t_ware_base表的空格

UPDATE T_WARE_BASE
SET
  wareid = TRIM(wareid),
  warename = TRIM(warename),
  waregeneralname = TRIM(waregeneralname),
  warespec = TRIM(warespec),
  factoryid = TRIM(factoryid),
  wareunit = TRIM(wareunit),
 fileno =  nvl(TRIM(fileno),'-'),
  wareabc = TRIM(wareabc),
  warecode = TRIM(warecode),
  areacode = TRIM(areacode),
  stamp = TRIM(stamp),
  bpwareid = TRIM(bpwareid),
  barcode = TRIM(barcode),
  lastmodify = nvl(TRIM(lastmodify),168),
  lasttime = TRIM(lasttime),
  taxcode = TRIM(taxcode),
  status = TRIM(status),
  purstatus = TRIM(purstatus),
  salestatus = TRIM(salestatus),
  purtax = TRIM(purtax),
  areaname = TRIM(areaname),
  listing_holder = TRIM(listing_holder),
  hold_valid_date = TRIM(hold_valid_date),
  warename_bak = TRIM(warename_bak),
  waregeneralname_bak = TRIM(waregeneralname_bak);