VIEW: OLAPSYS.ALL$OLAP_FUNCTION_PARAMETERS

Source

View Text - Preformatted

SELECT
  f.name function_name
, p.name parameter_name
, d.name data_type
, p.shortdescription parameter_type
, p.length length
, p.precision precision
, p.scale scale
, p.input_fk_seq position
FROM
  cwm$function f
, cwm$parameter p
, cwm$domain d
WHERE f.irid = p.operation_irid
AND p.type_irid = d.irid (+)
WITH READ ONLY

View Text - HTML Formatted

SELECT F.NAME FUNCTION_NAME
, P.NAME PARAMETER_NAME
, D.NAME DATA_TYPE
, P.SHORTDESCRIPTION PARAMETER_TYPE
, P.LENGTH LENGTH
, P.PRECISION PRECISION
, P.SCALE SCALE
, P.INPUT_FK_SEQ POSITION FROM CWM$FUNCTION F
, CWM$PARAMETER P
, CWM$DOMAIN D WHERE F.IRID = P.OPERATION_IRID AND P.TYPE_IRID = D.IRID (+) WITH READ ONLY