`
wangchangtao
  • 浏览: 18662 次
  • 性别: Icon_minigender_1
  • 来自: 石家庄
社区版块
存档分类
最新评论
文章列表
create or replace procedure table_procedure AS i_count integer; begin   select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='TABLE' and t.OBJECT_NAME = upper('tableName');     if i_count>0 then         EXECUTE IMMEDIATE 'drop table tableName purge';     end if; end table_procedu ...
Oracle8i及以上版本中可以创建两种临时表: 1.会话临时表   CREATE GLOBAL TEMPORARY TABLE_NAME (column specification)     ON COMMIT PRESERVE ROWS; 2.事务临时表     CREATE GLOBAL TEMPORARY TABLE_NAME (column specification)     ON COMMIT DELETE ROWS; --ON COMMIT D ...
create or replace procedure type_procedure AS i_count integer; begin   select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='TYPE' and t.OBJECT_NAME = upper('type_name');     if i_count>0 then         EXECUTE IMMEDIATE 'drop type type_name';     end if; end type_procedure; / call ...

创建视图样例

create or replace view view_name as select tm.stbid,tm.begintime,tm.endtime,tm.status from tablename1 tm union all select ta.stbid,ta.begintime,ta.endtime,ta.status from tablename2 ta;

创建job样例

CREATE OR REPLACE PROCEDURE job_procedure AS   i_count    INTEGER;   v_job      VARCHAR2(128);   v_schedule VARCHAR2(128); BEGIN   v_job := upper('job_name');   SELECT COUNT(*)     INTO i_count     FROM user_objects t    WHERE t.OBJECT_TYPE = 'JOB'          AND t.OBJECT_NAME = upper(v_job);   IF i_co ...

创建函数样例

create or replace procedure function_procedure AS i_count integer; begin   select count(*) into i_count from user_objects t where t.OBJECT_TYPE ='FUNCTION' and t.OBJECT_NAME = upper('function_name');     if i_count>0 then         EXECUTE IMMEDIATE 'drop function function_name';     end if;     ...

ajax方式提交form

    博客分类:
  • ajax
思路: 1.创建一个iframe   if(window.ActiveXObject)   {        var io = document.createElement('<iframe id="' + frameId  + '" name="' + frameId + '" />');       if(typeof uri== 'boolean'){          io.src = 'javascript:false';       }       else if(typeof uri== 'string'){          i ...
Timer调用cancel后,不能再绑定任何TimerTask,只能在重新生成Timer
Global site tag (gtag.js) - Google Analytics