DBA Source

-- ##############################################################################
-- DBA SOURCE ETC
-- ##############################################################################

  SELECT owner,
         name,
         line,
         text
    FROM dba_source
   WHERE type = 'PACKAGE'
     AND owner = 'APPS'
     AND name LIKE 'XX%'
     AND lower(text) LIKE '%connect%'
ORDER BY line;

	select owner
	     , name
		 , type
		 , line
		 , (replace(replace(text,chr(10),''),chr(13),' ')) text 
	  from dba_source 
	 where (substrb(name,1,3) = 'PA_' OR dubstrb(name,1,4) = 'PJI_')
	   and line=2 and type in ('PACKAGE','PACKAGE BODY')
	order by name; 

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*