What is the abbreviation for wm in wm

There are lots of aggregation functions in the Oracle database with the prefix wm_, such as wm_concat. What does wm mean?

CodePudding user response：

Workspace Manager, which still exists.

The function used to be under the WMSYS schema. You can see it's removal referred to in this support document, where an older version was queried (quoting from the public part):

select * from SYS.DBA_TAB_PRIVS WHERE PRIVILEGE = 'EXECUTE' and OWNER = 'WMSYS';
WM_CONCAT_IMPL
WM_CONCAT
WM$GETDBVERSIONSTR
WM$DISALLOWQNDML
WM$CONVERTDBVERSION
OWM_9IP_PKG

Of course, it was never officially supported and shouldn't have been used other than by internal Oracle tools, and it not longer exists.