It seems, that Stack Overflow doesn't recognise the SQL:2003/SQL:2008 MERGE
statement, as can be seen in my answer here:
Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
or here:
merge into table_a u
using (select id, rownum rnum from table_a order by column1, column2) s
on (u.id = s.id)
when matched then update set u.sequence_column = s.rnum
these keywords are not recognised: merge
, using
, matched
I'm not sure if this is a bug or a feature request.
UPDATE: I was asked to look for some more keywords. I can confirm, these standard ones are not recognised either:
partition
rows
unbounded
preceding
following
row
And these Oracle-specific ones might be interesting too http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/ap_keywd.htm
ACCESS, AUDIT, CHAR, CLUSTER, COMMENT, COMPRESS, CONNECT, DATE, DECIMAL, EXCLUSIVE,
FLOAT, IDENTIFIED, IMMEDIATE, INCREMENT, INITIAL, INTEGER, LEVEL, LOCK, LONG,
MAXEXTENTS, MINUS, MLSLABEL, MODE, MODIFY, NOAUDIT, NOCOMPRESS, NOWAIT, NUMBER,
OFFLINE, ONLINE, PCTFREE, PRIOR, PRIVILEGES, RAW, RENAME, RESOURCE, ROW, ROWID,
ROWNUM, ROWS, SESSION, SHARE, SIZE, SMALLINT, START, SUCCESSFUL, SYNONYM, SYSDATE,
UID, VALIDATE, VARCHAR, VARCHAR2, WHENEVER