Oracle Find Packaged Procedure
This script searches for procedures داخل Oracle packages based on a supplied procedure name pattern. It queries the DBA_PROCEDURES view to display package owner, package name, and matching procedure names, helping developers quickly locate packaged procedures in the database.
oraclesqlreporting-analyticsv1.0.0
0 stars0 downloads14 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/find_packaged_proc.sql
-- Author : Tim Hall
-- Description : Displays tablespaces the user has quotas on.
-- Requirements : Access to the V$ views.
-- Call Syntax : @find_packaged_proc {procedure_name}
-- Last Modified: 16-JAN-2024
-- -----------------------------------------------------------------------------------
set verify off
column owner format a30
column object_name format a30
column procedure_name format a30
select owner, object_name, procedure_name
from dba_procedures
where object_type = 'PACKAGE'
and procedure_name like '%' || upper('&1') || '%';