query to get the code of package, procedure,function

SELECT replace(replace(text,CHR(13),''),CHR(10),' ') FROM all_source where name like 'JM_MAKE856_NEW' order by line;

No comments:

Post a Comment

WIP Tables with description

  Table Name Description     WIP_ACCOUNTING_CLASSES stores accounting flexfield information for standard discrete jobs, non-standard asset j...