declare
--------存储过程
create or replace procedure delete_base_target_users Authid Current_User is
begin
execute immediate 'create table tb_test(id number(1))';
commit;
end delete_base_target_users;
--------job
job number;
begin
sys.dbms_job.submit(job => job,
what => 'delete_base_target_users;',
next_date => sysdate+1/(24*60),
interval => 'trunc(sysdate,''mi'')+1/(24*60)');
commit;
end;
https://bbs.csdn.net/topics/392282180
create 前面怎么没有drop table 表都存在了,再建。。
(void)layoutSubviews {
[super layoutSubviews];
CGFloat createViewW = SCREEN_WIDTH - 60 * SCREEN_Ratio;
CGFloat titleLabH = 40 * SCREEN_Ratio;
_titleLab.frame = CGRectMake(0, 0, createViewW, titleLabH);
CGFloat inputFieldY = CGRectGetMaxY(_titleLab.frame) + 25 * SCREEN_Ratio;
CGFloat inputFieldX = 15 * SCREEN_Ratio;
CGFloat inputFieldW = createViewW - 2 * inputFieldX;
CGFloat inputFieldH = 40 * SCREEN_Ratio;
_inputField.frame = CGRectMake(inputFieldX, inputFieldY, inputFieldW, inputFieldH);
CGFloat doneBtnY = 0;
if (_needInputField) {
doneBtnY = CGRectGetMaxY(_inputField.frame) + 35 * SCREEN_Ratio;
} else {
doneBtnY = CGRectGetMaxY(_inputField.frame) + 15 * SCREEN_Ratio;
}
CGFloat doneBtnH = 30 * SCREEN_Ratio;
CGFloat doneBtnW = 50 * SCREEN_Ratio;
CGFloat doneBtnX = (createViewW - 2 * doneBtnW) / 3;
_doneBtn.frame = CGRectMake(doneBtnX, doneBtnY, doneBtnW, doneBtnH);
CGFloat cancelBtnX = CGRectGetMaxX(_doneBtn.frame) + doneBtnX;
_cancelBtn.frame = CGRectMake(cancelBtnX, doneBtnY, doneBtnW, doneBtnH);
CGFloat createViewH = CGRectGetMaxY(_doneBtn.frame) + 20 *SCREEN_Ratio;
_createView.size = CGSizeMake(createViewW, createViewH);
_createView.center = self.center;
}