One more obscure syntax

As 10g introduced MODEL, which is mostly used to impress your colleagues but seldom used in production, 12c has a new syntax, MATCH_RECOGNIZE I gave it a first try to recognize trends in EMPs salaries over hire date. SELECT ename, hiredate, sal, trend FROM emp MATCH_RECOGNIZE ( ORDER BY hiredate MEASURES CLASSIFIER () AS TREND… Continue reading One more obscure syntax

Categorized as sql Tagged