|
ACS3 Data Model |
||||||||||||
|
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|---|---|---|---|---|---|
FUNCTION_NAME | VARCHAR2(30.0) | Y | NO | NO | NO | |
LINE_COUNT | NUMBER(38) | Y | NO | NO | NO |
select lower(Name) as function_name, count(*) as line_count from USER_SOURCE where Type = 'FUNCTION' and Name like 'HP_%' and Name != 'HP_FUNCTIONS' group by Name order by Name