Problem

Sequence reference pages omit IvorySQL Oracle-mode dot notation and clauses such as SESSION, GLOBAL, SCALE, EXTEND, and NOCACHE, while some accepted clauses currently have limited runtime behavior.

Proposed change

Document supported creation, alteration, and access syntax with defaults, examples, compatibility differences, and explicit implementation limits.

Acceptance criteria

• Oracle-mode defaults and mandatory keywords are accurate.
• Session/global and scalable sequence behavior is explained.
• Parse-only or limited clauses are clearly identified.
• The complete SGML validation passes.