ALL_MACRO_PARAMETERS

ALL_MACRO_PARAMETERS displays parameters for the SQL macros accessible to the current user.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the macro to which the parameter belongs
MACRO_NAME VARCHAR2(128) NOT NULL Name of the macro to which the parameter belongs
SUB_ID NUMBER   Reserved for future use
SUB_NAME VARCHAR2(128)   Reserved for future use
PARAM_NAME VARCHAR2(128)   Parameter name
PARAM_ID NUMBER NOT NULL Parameter ID
PARENT_ID NUMBER   If the parameter is a table column, then the PARAM_ID of that table parameter. Otherwise, the PARAM_ID for the parameter itself.
FORMAL_ID NUMBER   For format parameters, the parameter position. Otherwise, for table columns and the return value, null.
IS_COLUMN BOOLEAN   Indicates whether the parameter is a table column (TRUE) or not (FALSE)
IS_RETURN BOOLEAN   Indicates whether the parameter is a return value (TRUE) or not (FALSE)
DATA_TYPE VARCHAR2(106)   Data type of the parameter
DATA_LENGTH NUMBER   Length of the parameter (in bytes)
DATA_PRECISION NUMBER   Decimal precision for a NUMBER data type; binary precision for a FLOAT data type, null for all other data types
DATA_SCALE NUMBER   Number of digits to the right of the decimal point in a number; null for all other data types
CHARACTER_SET_NAME VARCHAR2(44)  

For character type columns, the name of the character set for the column:

  • CHAR_CD
  • NCHAR_CS
CHAR_COL_DECL_LENGTH NUMBER   For character type columns, the declared length of the column (in bytes)
COLLATION VARCHAR2(100)   For character type parameters, the collation for the parameter</p><p>If a collation was not specified, the value of this column is null.</p> {:/}
CHAR_LENGTH NUMBER   For character type parameters, the length of the column (in characters)
DEFAULT_VALUE CLOB   Default value for the parameter

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.4.

See Also: