oracle list program

1-- Depending on connected user grants:
2SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
3SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
4SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');

1-- Depending on connected user grants:
2SELECT * FROM ALL_SCHEDULER_PROGRAMS ORDER BY OWNER, PROGRAM_NAME;
3SELECT * FROM DBA_SCHEDULER_PROGRAMS WHERE OWNER = 'schema_name';
4SELECT * FROM USER_SCHEDULER_PROGRAMS;