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

10 votes191 views2 answers
What is database
SQL
1 vote174 views2 answers
Mysql select tables with name like
SQL
0 vote161 views1 answer
Postgresql subquery
SQL
0 vote188 views1 answer
Order child below the parent in mysqli
SQL
0 vote180 views1 answer
Retornar apenas o ano mysql date
SQL
6 votes197 views2 answers
How to get yesterday date in mysql
SQL
2 votes182 views1 answer
Sql missing records from another table
SQL
0 vote192 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote194 views2 answers
Cambiar nombre tabla mysql
SQL
3 votes175 views2 answers
Oracle sql truncate table
SQL