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

Similar codes

2 votes306 views1 answer
Where clause for child record apex
SQL
4 votes303 views1 answer
W3schools create table
SQL
2 votes280 views4 answers
Mysql select into new table
SQL
0 vote273 views1 answer
Sql delete dastabase
SQL
0 vote300 views1 answer
Add a new column into table
SQL
4 votes287 views1 answer
Mysql copy table with new name
SQL
0 vote280 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
-1 vote308 views1 answer
Get month and year from date in mysql sequelize
SQL
3 votes283 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
10 votes285 views1 answer
Oracle dependencies table
SQL