文章列表
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;
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;
...
思路:
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