Oracle create_program

BEGIN
  -- PL/SQL Block.
  DBMS_SCHEDULER.create_program (
    program_name   => 'test_plsql_block_prog',
    program_type   => 'PLSQL_BLOCK',
    program_action => 'BEGIN my_job_proc(''CREATE_PROGRAM (BLOCK)'');
END;',
    enabled        => TRUE,
    comments       => 'CREATE_PROGRAM test using a PL/SQL block.');
END;

Source: dba-oracle.com

Similar codes

0 vote196 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote149 views1 answer
Java input type sql date
SQL
3 votes168 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote256 views3 answers
Osx stop mysql service
SQL
1 vote178 views1 answer
Increase existing date in sql oracle
SQL
4 votes166 views1 answer
T-sql get duplicate rows
SQL
0 vote156 views1 answer
Denormalise SQL command
SQL
0 vote144 views1 answer
Oracle list index on table
SQL
0 vote172 views1 answer
No query unable to fetch row sqlite
SQL
1 vote149 views1 answer
Sql restore backup query
SQL