Using STRAGG in 11g
ProhanNov 25 2009 — edited Nov 26 2009Does STRAGG work with Oracle 11g? I just tried to use it but returned an error message. Here is exactly what I did:
SQL> select STRAGG(permit_number) from gillnet_vessel where rownum < 6;
select STRAGG(permit_number) from gillnet_vessel where rownum < 6
*
ERROR at line 1:
ORA-00904: "STRAGG": invalid identifier
STRAGG works in 10g.
Here's my banner:
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production