Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

HP_FUNCTIONS

Columns

NameTypeNullableInsertableUpdatableDeletableComment
FUNCTION_NAMEVARCHAR2(30.0)YNONONO 
LINE_COUNTNUMBER(38)YNONONO 

Query:

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


Generated by OraSchemaDoc, (c) Aram Kananov, 2002