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

-2 votes148 views2 answers
Add auto_increment column to existing table mysql
SQL
1 vote129 views1 answer
Set statistics on in ssms
SQL
2 votes149 views3 answers
Replace null in sql
SQL
2 votes141 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote147 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote133 views1 answer
How to find username and password in oracle 18c
SQL
0 vote137 views1 answer
Check psql validity function
SQL
0 vote153 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote136 views1 answer
Sqlcmd no headers
SQL
0 vote134 views1 answer
Teller stamp , bmo , PDF
SQL