概要：promptprompt Creating procedure SP_CREATETAB_TBL_PROGRAMME prompt = prompt create or replace procedure sp_createtab_tbl_programme Authid Current_User as tabname varchar(200); begin select ’TBL_PROGRAMME_’ || to_char(sysdate, ’yyyymmdd’) into tabname from dual; --create table tabname as select * from tbl_programme where 1 != 1; execute immediate ’create table ’ || tabname ||’ tablespace p2p as select * from tbl_programme where 1 != 1’; com...
Oracle通过job定时创建表(1),标签：ciw认证考试,oracle认证,http://www.suxue6.com
promptprompt Creating procedure SP_CREATETAB_TBL_PROGRAMME
prompt =============================================
prompt
create or replace procedure sp_createtab_tbl_programme
Authid Current_User
as
tabname varchar(200);
begin
select ’TBL_PROGRAMME_’ || to_char(sysdate, ’yyyymmdd’) into tabname from dual;
--create table tabname as select * from tbl_programme where 1 != 1;
execute immediate ’create table ’ || tabname ||’ tablespace p2p as select * from tbl_programme where 1 != 1’;
commit;
end;
/
VARIABLE testjobid number;
begin
sys.dbms_job.submit(:testjobid,’sp_createtab_tbl_programme;’,trunc(sysdate+1)+1/24,’trunc(sysdate+1)+1/24’);
commit;
end;
/
spool off
上一页 [1] [2]
Tag:ORACLE/CIW认证，ciw认证考试,oracle认证，考试频道 - 计算机考试 - ORACLE/CIW认证
