随笔分类 -  Oracle

摘要：select * from (select prdt_no, bal from TEST_PIVOT where date_code >='20151121' and date_code<='20151123' ) pivot (sum(bal) as bal for prdt_no in ('1... 阅读全文

摘要：/** * 字符串分割函数. * @param P_STR 待分割的字符串 * @param 分隔符 * @return 自定义table类型TY_STR_SPLIT. * 使用方法 select column_value from table(fn_split('1,2',',')) * @Aut... 阅读全文

摘要：/** * 判断str1是否包含str2. * @param str1 数组型字符串，以逗号分割 * @param str2 * @return 如果str1包含str2，则返回1，否则返回-1 * @Author: xDer */create or replace function exinstr... 阅读全文

摘要：查看计划任务的日志 select * from user_scheduler_job_log select * from user_scheduler_job_run_details 查看正在运行的job select sid,job from dba_jobs_running; 查看所有的job select ju.name username, j.obj#, jo.name, j.fail... 阅读全文

摘要：1. What Is a Transaction?A transaction is a logical unit of work requested by a user to be applied to the database objects. Oracle server introduces t... 阅读全文

摘要：create or replace procedure SP_MAIL_SENDER(p_recipient IN VARCHAR2, --收件人 p_subject IN VARCHAR2, --主题 ... 阅读全文