![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
liyvzheng
这个作者很懒,什么都没留下…
展开
-
Oracle定时器使用
创建job declarejobno number;begindbms_job.submit(jobno,'begin update table1 set a=''test''; end;',trunc(sysdate)+1,'trunc(sysdate)+1');end;这里第一个参数是任务编号,系统自动赋值。也可以采用isubmit来手动指定第二个参数是需要执行的任务过程...原创 2012-08-15 10:14:28 · 402 阅读 · 0 评论 -
Oracle 游标(显示+隐式)
1、显示游标 declare cursor cur_1 is select a.cust_name from ea_cust.cust_info a; cust_name varchar2(100); begin open cur_1; loop fet...原创 2012-08-15 10:38:59 · 103 阅读 · 0 评论 -
Oracle_select from where start with connect by prior子句用法
Oracle中select from where start with connect by prior子句用法connect by 是结构化查询中用到的,其基本语法是:select ... from tablenamewhere 条件3start with 条件1connect by 条件2;例:select * from tablestart with org_id = 'HBHqfWGWPy...原创 2012-08-27 11:23:17 · 244 阅读 · 0 评论