Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: how to change table name in sqlite 
Sql :: postgresql print variable 
Sql :: postgres alter table add primary key 
Sql :: stop mysql ubuntu 
Sql :: mysql cannot delete or update a parent row 
Sql :: grant lock tables privilege mysql 
Sql :: CREATE DATABASE db; SyntaxError: Unexpected identifier 
Sql :: mysql text type max length 
Sql :: oracle compile schema 
Sql :: sql drop primary key 
Sql :: mysql monthname 
Sql :: copy column data to another column sql with creating slugs 
Sql :: oracle cpu per session 
Sql :: mysql remove last empty newline 
Sql :: mysql get random row 
Sql :: get current year sql 
Sql :: show sqlite column names 
Sql :: sql print all names that start with a given letter 
Sql :: postgres update column with value from another table 
Sql :: sql remanecolumn 
Sql :: postgres check blocking 
Sql :: laravel to sql 
Sql :: install mysql in amazon linux 2 
Sql :: sql delete records older than 1 day 
Sql :: What is the compatibility level of a SQL database 
Sql :: inner join just one row 
Sql :: mysqldump password 
Sql :: oracle cannot access v$session 
Sql :: delete all table oracle 
Sql :: get first n letter of department name in sql 
ADD CONTENT
Topic
Content
Source link
Name
2+2 =