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.
