06 2018 档案

oracle将一个字段拆分成多个值 (regexp_substr函数)
摘要：select regexp_substr(p.attributename, '[^,]+',1,level) c1from tablename p connect by level <= length(p.attributename) - length(replace(p.attributename 阅读全文
posted @ 2018-06-28 15:59 Debugs 阅读(7900) 评论(0) 推荐(0)
当条件满足时 触发器做增删改
摘要：create or replace trigger trg_tab_sorting_theme_change before insert or update of PACKAGE_TYPE or delete on TAB_SORTING_THEME for each rowdeclare -- l 阅读全文
posted @ 2018-06-25 19:31 Debugs 阅读(265) 评论(0) 推荐(0)