oracle list procedures
-- Depending on connected user grants:
SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');
SELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE');oracle show running procedures
SELECT 'CALLED PLSQL' AS STATUT,
VS.USERNAME,
VS.OSUSER,
VS.PROGRAM,
VS.MODULE,
VS.ACTION,
VS.SQL_EXEC_START,
D_O.OBJECT_NAME,
D_O.OBJECT_TYPE
FROM DBA_OBJECTS D_O
INNER JOIN V$SESSION VS ON D_O.OBJECT_ID = VS.PLSQL_ENTRY_OBJECT_ID
UNION ALL
SELECT 'CURRENT PLSQL' AS STATUT,
VS.USERNAME,
VS.OSUSER,
VS.PROGRAM,
VS.MODULE,
VS.ACTION,
VS.SQL_EXEC_START,
D_O.OBJECT_NAME,
D_O.OBJECT_TYPE
FROM DBA_OBJECTS D_O
INNER JOIN V$SESSION VS ON D_O.OBJECT_ID = VS.PLSQL_OBJECT_ID;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
