-
编辑 删除
rman学习笔记
=================== rman 备份===================-- 备份集database 备份run{configure channel device type disk maxpiecesize 2G;backup device type disk format 'F:appback_2009ss%d_%s_%p.dbf' database;sql 'alter system archive log current';}-- 基于不完全恢复后的数据库全备.run{configure channel device type disk maxpiecesize 2G;delete noprompt backup; delete noprompt copy;backup device type disk format 'F:appback_2009ss%d_%s_%p.dbf' database;sql 'alter system archive log current';}run {configure ex
-
编辑 删除
PL/SQL代码记事
CREATE OR REPLACE FUNCTION DATA_USER."FUJIAIPC_OLD" (in_ipc in varchar2, --输入老版本附加分类号in_main in varchar2 --输入老版本主分类号作为备用的小类号) return varchar2 isipc varchar2(4000);strReturn varchar2(4000);xl varchar2(444) := null; --前4位小类号xl2 varchar2(4) := null; --备用前4位小类号ipc1 varchar2(4000);ipc2 varchar2(4000);ipc3 varchar2(4000);xl3 varchar2(10) := null;i int;j int;k int;m int;n int;g int;beginipc := null;ipc1 := null; --循环中截取段判断ipc2 := null; --4位后4位
