Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle procedure chain step

-- Get procedure starded by a chain step
SELECT s.OWNER, S.CHAIN_NAME, s.STEP_NAME, p.PROGRAM_ACTION
FROM DBA_SCHEDULER_CHAIN_STEPS s
LEFT JOIN DBA_SCHEDULER_PROGRAMS p ON s.PROGRAM_NAME = p.PROGRAM_NAME
WHERE s.STEP_NAME ='MY_STEP';
Comment

PREVIOUS NEXT
Code Example
Sql :: odoo there is no primary key for referenced table "res_users" 
Sql :: order records between two cordinates sql 
Sql :: ring get a list of tables inside the database using the odbc_tables() 
Sql :: id INT NOT NULL AUTO_INCREMENT 
Sql :: mamp mysql config file 
Sql :: sql server: how to assign value to table variable returned from function 
Sql :: select count(*) from table 
Sql :: sql server query field names 
Sql :: md5 encryption for existing records 
Sql :: combine islands dates sql 
Sql :: date query 
Sql :: implizite joins sql 
Sql :: how get data from database if id not found then search another column 
Sql :: redshift alter table alter column set not null 
Sql :: sql server import json 
Sql :: postgresql custom order by 
Sql :: how much space does sql server take per row 
Sql :: select save as table postgres 
Sql :: extract sql from query object sqlalchemy 
Sql :: sql cursor example multiple columns 
Sql :: create bakupd database sqlserver 
Sql :: get who is hired in january in sql 
Sql :: copy table from postgresql to mysql 
Sql :: ring connect to the database using the odbc_connect() 
Sql :: sql to c# linq converter online 
Sql :: mysql edit trigger 
Sql :: create sql table 
Sql :: TSQL select 50 records at a time 
Sql :: pg_dump backup postgresql 
Sql :: join 
ADD CONTENT
Topic
Content
Source link
Name
8+8 =