摘要:
环境介绍: 根据业务表的object_id 和 对照表中的dm_old的对照关系,更新业务表的object_id为 对照表中的dm_new --1. 对照表1.1 drop table hy0921_tmp purge;1.2 create table hy0921_tmp(dm_old numbe 阅读全文
摘要:
declare my_data table_name%rowtype; my_num number;begin select col1,col2 into my_data from table_name t where col_name = '110101201605165'; for my_num 阅读全文