CREATE OR REPLACE PROCEDURE  hm_gx_zlwz @cywdm NUMBER(10) AS   
BEGIN
  CREATE table lsb AS SELECT * FROM yw_sxcd  WHERE ywdm=@cywdm
  UPDATE lsb SET zlwz='8'
  DELETE FROM yw_sxcd WHERE ywdm=@cywdm
  insert into yw_sxcd SELECT  *  from lsb
  drop   table lsb
END

CREATE PROCEDURE  hm_gx_zlwz
  @cywdm Numeric(10)
   AS   
BEGIN
  CREATE table lsb ( yw_sxcd 表的字段与属性 ... )
  UPDATE lsb SET zlwz='8' && && 未改
  DELETE FROM yw_sxcd WHERE ywdm=@cywdm
  insert into yw_sxcd SELECT  *  from lsb && 未改
  drop table lsb
END