| create table [message #65227] |
Mon, 21 June 2004 18:33  |
ECI
Messages: 10
Registered: May 2004
|
Junior Member |
|
|
how to create a table every day with a variable name of test_date.
I need to create a table every day every 3am and named that as test_date.
date is variable.
How to do that... thank you
|
|
|
|
|
|
|
|
| Re: create table [message #65230 is a reply to message #65229] |
Tue, 22 June 2004 21:02  |
Ajendra
Messages: 165
Registered: February 2004
|
Senior Member |
|
|
Yes its included in 9i. Here is a sample example. You can get plenty of example on this in net.
CREATE OR REPLACE procedure daip_clear_event_log_job
is
v_job number:=90;
dt1 date:=to_date('06-jan-2004 10:00:00','dd-mon-yyyy hh:mi:ss');
begin Dbms_Job.iSubmit ( job => v_job, what => 'YOUR_PROC_NAME;', next_date => dt1, interval => 'sysdate + 1');
Dbms_Job.Run ( v_job );
Dbms_Output.Put_Line ( 'Submitted as job # ' || to_char ( v_job ) );
end;
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
