• 博客访问: 96753
  • 博文数量: 47
  • 用 户 组: 普通用户
  • 注册时间: 2013-11-23 01:02





发布时间:2005-04-13 00:21:55

Subhash -- Thanks for the question regarding "DBMS_JOB -- how to pass parameters to the job", version 8.0.5originally submitted on 11-Mar-2001 23:13 Eastern US time, last updated 11-Apr-2005 13:18Tom's latest followup | GOTO a Bookmarkable Page | Bottom You Asked (Jump to Tom's latest followup)Hi Tom   I have one procedure execute_job with two in parameters    (batchnumber and loaddate). Procedure as follows :-create or replace procedure execute_job(batchnumber in n......【阅读全文】

阅读(1360) | 评论(0) | 转发(0)

发布时间:2005-04-11 22:22:25

昨天出于无聊, 测试了一下关于Oracle9idual表的相关处理.发现一个问题, 对于很小的表, 使用full table 桑蚕并不是最好的选择..:-)SQL> create table dual_x(dummy varchar2(1) primary key);Table created.SQL> insert into dual_x values('X');1 row created.SQL> commit;Commit complete.SQL> select * from dual_x;D                                ......【阅读全文】

阅读(1116) | 评论(0) | 转发(0)

发布时间:2005-04-07 16:37:24

出于无聊写了这个函数, 供大家赏玩.:-)上次贴这个数据的时候, 忘记将对应的数据类型贴出来, 这里将他补齐.create type DATABAK.date_obj as object (    month varchar2(20),    sun char(2),    mon char(2),    tue char(2),    wed char(2),    thu char(2),    fri char(2),    sat char(2));create type DATABAK.date_obj_tab as table of date_obj;function DATABAK.get_date_str(in_date in date def......【阅读全文】

阅读(1393) | 评论(0) | 转发(0)

发布时间:2005-04-06 13:50:45

Hi Tom,We have a similar requirement to have global values accesible across multiple sessions.We are currently in the process of upgrading to 9i, and was thinking of using the global context feature to do that.Can you provide us with a simple example to do this on 9i using global context?Appreciate your help,Thanks, Followup:  ops$tkyte@ORA920> create or replace context App_Ctx using My_pkg  2  ACCESSED GLOBALLY  3  /Context created.ops$tkyte@ORA920>ops$tkyte@......【阅读全文】

阅读(1696) | 评论(0) | 转发(0)

发布时间:2005-04-06 11:21:30

Reviewer: hk from Finland Original questioner asked also:"How do I know if I actually do need 3.5G undo spaceor Oracle is not reusing the undo space where it shouldbe?"That is good question anyhow and it's still open here?If undo_tablespace size is 100Megs and we run some batch job, which take 95megs undo space. Now, batch job is done and undo_tablespace is 95% full. Then immediately starts another transaction and it needs over 5 megs undo space. Is undo_retention ignored and trans......【阅读全文】

阅读(1472) | 评论(0) | 转发(0)

jametong2014-06-27 16:58


回复  |  举报

登录 注册