---
title: "实用小SQL"
author: "hotjava"
date: "2010-04-08T23:57:00Z"
tags: []
categories: ["数据库"]
slug: "sql"
draft: false
lastmod: "2010-04-08T23:59:33Z"
id: 638514
url: "https://hotjava.iteye.com/blog/638514"
---

1、刷数据

DECLARE  
  CURSOR T1 IS  
    SELECT * FROM wo;  
BEGIN  
  FOR REC IN T1 LOOP  
    UPDATE wo w  
       SET W.wo\_staff\_id   = REC.sgdd\_id  
     WHERE W.WO\_NBR = REC.WO\_NBR;  
  END LOOP;  
END;