ALL_MACROS

ALL_MACROS displays SQL macros accessible to the current user.

Related Views

• DBA_MACROS displays all SQL macros in the database.

• USER_MACROS displays SQL macros owned by the current user.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)	NOT NULL	Owner of the macro
NAME	VARCHAR2(128)	NOT NULL	Name of the macro
SUB_ID	NUMBER		Reserved for future use
SUB_NAME	VARCHAR2(128)		Reserved for future use
PARAM_COUNT	NUMBER	NOT NULL	Number of formal parameters for the macro
DEFINITION	CLOB		Text of the macro definition
ON_OBJECT_ID	NUMBER		If a table is specified in the ON clause for the macro, the object number of the table. Otherwise, null.

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

See Also:

• “DBA_MACROS”

• “USER_MACROS”