weixin_50920119的博客

create or replace procedure dbcheck.data_save (OUT_FLAG out VARCHAR2, OUT_MESSAGE out varchar2)isbeginmerge into DBCHECK.DB_USER ausing (select instance_id ,username ,account_status ,created ,ins_date from

ORACLE存储过程ORACLE存储过程create or replace procedure dbcheck.data_save isbegin insert into DBCHECK.DB_USER a(hostid,username,account_status,created,last_modify_date)with t as(select b.dbid,b.username,b.account_status,b.created,b.ins_date,row_number()