This script will do a fast search on all database objects. @obj fnd will find all fnd% database objects. Also shows if object is invalid. This script is essential for finding objects in the 340.000 objects in an Oracle Applications database. Use copy/paste for execution of the describe. SQL> @obj fnd_glo OBJECT_NAME OBJECT_TYPE ---------------------------------------- -------------------- desc APPS.FND_GLOBAL — PACKAGE desc APPS.FND_GLOBAL — PACKAGE BODY desc APPS_MRC.FND_GLOBAL — SYNONYM SQL> Syntax: @obj <partial object name>
Download: sql4oracle.zip - all sql4oracle scripts - posted 14-03-2013