Skip to content

Using PL/SQL Code Completion

This topic describes the code completion functionality provided for PL/SQL files. Ctrl-Space after a space will provide all the elements available for code completion for that context, while any preceding text will filter the elements. A dot followed by an identifier will provide suitable sub elements of that element.

  • Code Completion at a general location will provide all the Packages, Views and Tables of the database and relevant Local Variables, Types and Cursors
  • A dot followed by a View/Table/Cursor/Type identifier will provide the Columns/Fields of the relevant construct.
  • A dot followed by a Package identifier will provide the Variables and Methods of the Package