Tuesday, April 19, 2022

DB - Check the status for all type of objects using user_objects

 Query:

select object_type, object_name, status from user_objects where object_type in ('FUNCTION','PROCEDURE','PACKAGE','PACKAGE BODY','TRIGGER') order by object_type,object_name;




No comments:

Post a Comment

Featured Post

OIC File Handling – Removing .pgp and Preserving .csv (Dynamic File Name Logic) | use of ast-index-within-string() function

๐Ÿ“Œ Problem Statement In Oracle Integration Cloud (OIC), while working with Stage File, we often receive source files like: a.b.c.csv.pgp ๐Ÿ” ...