Phrase Completion

Code Completion suggests not only separate keywords and object names, but entire code phrases. The following code phrases are supported:

  • ORDER MEMBER
  • INNER JOIN
  • CROSS JOIN
  • COMMENT ON
  • GLOBAL TEMPORARY TABLE
  • TEMPORARY TABLE
  • TEMPORARY TABLESPACE
  • CONNECT BY
  • FOR UPDATE
  • START WITH
  • AS RESULT
  • AS OF
  • PARTITION BY
  • REJECT LIMIT
  • SEGMENT CREATION
  • ROLLBACK SEGMENT
  • FLASHBACK ARCHIVE
  • DATABASE LINK
  • LOCK TABLE
  • DEFAULT DIRECTORY
  • DEFAULT TABLESPACE
  • BULK COLLECT
  • PRIMARY KEY
  • FOREIGN KEY
  • MATERIALIZED VIEW
  • NOT NULL
  • NOT MATCHED THEN INSERT
  • NOT IDENTIFIED

Example

INNER JOIN is prompted in the SELECT query.