To get the total number of lines inside a function, trigger, procedure, ect. We need to run our query against the
ALL_SOURCE table (describes the text source of the stored objects accessible to the current user). Or against the
USER_SOURCE table (describes the text source of the stored objects owned by the current user. Its columns (except for OWNER) are the same as those in ALL_SOURCE.
Counting the total lines is a no brainier, we just use oracle's max function and group by name and type. To get the total number of lines without the empty or "space" lines, I've used the DECODE function along with REPLACE and chr(10), the New Line character.
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|