Oracle step procedure

-- Get procedure started 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

0 vote296 views1 answer
Mysql subdate
SQL
0 vote338 views1 answer
What is metadata in sql
SQL
4 votes291 views2 answers
Show all database inside postgresql
SQL
0 vote274 views4 answers
How to drop all tables in sql
SQL
1 vote286 views3 answers
How to truncate foreign key constraint table
SQL
0 vote290 views1 answer
Power bi union columns
SQL
10 votes279 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote275 views1 answer
How to query all tables mysql at the same time
SQL
0 vote313 views1 answer
PGSQL dynamic table name
SQL
0 vote314 views1 answer
Mysql update all record removing 2 hours from column
SQL