![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
lyzimo
这个作者很懒,什么都没留下…
展开
-
oracle 表上创建触发器
/*INSERT触发器*/CREATE OR REPLACE TRIGGER 触发器名称BEFORE INSERTON 表名REFERENCING NEW AS NEW OLD AS OLDFOR EACH ROWdeclarenSeq number;begin-- todoend;/*update 触发器*/create or replace trigger 触发器名称 after update of checked_mark on 表名 for each row...原创 2021-05-12 17:26:29 · 490 阅读 · 0 评论 -
oracle 创建调度作业
查询所有调度作业select * from ALL_SCHEDULER_JOBS;查询当前用户调度作业select * from USER_SCHEDULER_JOBS;创建调度作业两种情况(1)begin sys.dbms_scheduler.create_job(job_name => 'sa.SCHED_JOB_YN', job_type => 'PLSQ...原创 2021-05-12 17:02:27 · 333 阅读 · 0 评论 -
oracle 按照表的不同字段进行统计数据
declare -- Local variables here ta varchar(100); sqlt varchar(1000); cursor va is select A.COLUMN_NAME from user_tab_columns Awhere TABLE_NAME='CPC_S_PAYMENT_DEDUCTION_FL' and A.COLUMN_NAME in('BILLING_RULE','NO_ACCOUNT_FLAG','AUTO_ORDER','...原创 2021-02-23 15:46:58 · 876 阅读 · 0 评论