复制一个含有LONG RAW字段的表 oracle 对LONG RAW 类型的字段数据从一个表搬到另一个表中
- create or replace procedure sp_del_dw (
- TY char ,
- TId char ,
- LReason char )
- is
- graph long raw;
- begin
- select photo into graph
- from Dweller
- where TempYear=TY and TempId=TId;
- insert into CancelDweller (
- ID,
- Name,
- Sex,
- Birthday,
- Education,
- Marriage,
- Alias,
- )
- select * from view_dw
- where TempYear=TY and TempId=TId;
- update CancelDweller
- set Photo=graph
- where TempYear=TY and TempId=TId;
- delete dweller where TempYear=TY and TempId=TId; -- delete the taker the same time
- commit;
- end sp_del_dw;
- /