Phrase Completion

Last modified: November 24, 2020

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.