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 vote190 views1 answer
Oracle select invalid views
SQL
1 vote196 views1 answer
How to see which columns are indexxed mysql
SQL
0 vote194 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
24 votes206 views5 answers
List mysql users
SQL
0 vote191 views1 answer
USING THE NOT CONDITION IN SQL
SQL
4 votes195 views1 answer
Mysql copy table with new name
SQL
6 votes204 views1 answer
Oracle rank
SQL
14 votes198 views3 answers
SQL trim
SQL
0 vote194 views1 answer
Vbscript clean up ADODB.Recordset
SQL
14 votes214 views3 answers
How to add default constraint in mysql
SQL