全部博文（101）
发布时间：2013-01-15 13:48:18
create table t1 as select sql_text from v$sqlarea;alter table t1 add sql_text_wo_constants varchar2(1000);create or replace function remove_constants(p_query in varchar2) return varchar2 as l_query long; l_char varchar.........【阅读全文】
发布时间：2013-01-08 10:29:41
create table tb_db_ddl_mobitor( ddl_time date, session_id varchar2(100) , os_user varchar2(100) , ......【阅读全文】
发布时间：2013-01-07 16:18:36
create or replace trigger tri_ddl_monitorbefore create or alter or drop or truncate on databasedeclare l_errmsg varchar2(100):= 'You have no permission to this operation';begin if ora_sysevent = 'CREATE' then raise_application_error(-20001, ora_dict_obj_owner || '......【阅读全文】
