Posted by : Arjun Lagisetty Monday, May 16, 2016

Below is the Query to get the list of all the functions and their implementations from the work repository. We had to write this because the code we inherited were using functions with in functions we wanted to find our which functions used other functions with in them so we understand the impact of changing functions on the overall code base.



SELECT SNP_UFUNC.I_UFUNC
,SNP_UFUNC.UFUNC_NAME AS "FUNCTION_NAME"
,SNP_UFUNC.GROUP_NAME AS "GROUP"
,SNP_TXT_HEADER_DEF.FULL_TEXT AS "DEFINITION"
,SNP_TXT_HEADER_DESC.FULL_TEXT AS "DESCRIPTION"
,SNP_TXT_HEADER_FUNC_IMPL.FULL_TEXT AS "IMPLEMENTATION"
,SNP_UFUNC_TECHNO.TECH_INT_NAME AS "TECH_NAME"
FROM SNP_UFUNC
LEFT OUTER JOIN SNP_TXT_HEADER AS SNP_TXT_HEADER_DEF ON SNP_TXT_HEADER_DEF.I_TXT = SNP_UFUNC.I_TXT_DEF
LEFT OUTER JOIN SNP_TXT_HEADER AS SNP_TXT_HEADER_DESC ON SNP_TXT_HEADER_DESC.I_TXT = SNP_UFUNC.I_TXT_DESC
LEFT OUTER JOIN SNP_UFUNC_IMPL ON SNP_UFUNC_IMPL.I_UFUNC = SNP_UFUNC.I_UFUNC
LEFT OUTER JOIN SNP_TXT_HEADER AS SNP_TXT_HEADER_FUNC_IMPL ON SNP_TXT_HEADER_FUNC_IMPL.I_TXT = SNP_UFUNC_IMPL.I_TXT_IMPL
LEFT OUTER JOIN dbo.SNP_UFUNC_TECHNO ON SNP_UFUNC_TECHNO.I_UFUNC_IMPL = dbo.SNP_UFUNC_IMPL.I_UFUNC_IMPL
WHERE SNP_UFUNC_TECHNO.TECH_INT_NAME LIKE '%' -- CHANGE THIS IF YOU WANT TO GET SPECIFIC DEFITION OF THE FUNCTIONS.
ORDER BY SNP_UFUNC.UFUNC_NAME

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty