ORACLE
我真的不叫苏图
保持热爱
展开
-
Oracle存储过程和merge into实例
create or replace procedure dbcheck.data_save (OUT_FLAG out VARCHAR2, OUT_MESSAGE out varchar2) is begin merge into DBCHECK.DB_USER a using (select instance_id ,username ,account_status ,created ,ins_date from原创 2022-03-29 17:25:27 · 1160 阅读 · 0 评论 -
ORACLE存储过程
ORACLE存储过程 ORACLE存储过程 create or replace procedure dbcheck.data_save is begin 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()原创 2022-03-14 09:14:53 · 211 阅读 · 0 评论