pl/sql help

[mikeyb10supra]

Guys I have a series of tables in a script I have created and need to run them all as one script rather than all individually ie once one table has been created begin creating the next and so on until it is finished. Is this something I can do with triggers?

 

 

Cheers

 

Mike

[johnny g]

Would it be easier to use DBMS_JOB or DBMS_SCHEDULER?

[mikeyb10supra]

Are they built in function within sql developer?

[johnny g]

They are within Oracle 10g onwards (well, DBMS_JOB was superceeded by DBMS_SCHEDULER) but I don't use SQL Developer. Try something like this:

begin

dbms_scheduler.create_job(

job_name => 'DEMO_JOB_SCHEDULE'

,job_type => 'PLSQL_BLOCK'

,job_action => 'begin package.procedure(''param_value''); end; '

,start_date => '01/01/2006 02:00 AM'

,repeat_interval => 'FREQ=DAILY'

,enabled => TRUE

,comments => 'Demo for job schedule.');

end;

 

from the SQL Developer console (if it has one).