Online Documentation for SQL Manager for Oracle
Working with database objects
Double-click an object group to expand/collapse the corresponding tree node.
Double-click an object to open it in the corresponding editor.
Right-click an object to display its context menu which allows you to perform various operations over the selected object or database.
If you want to use the DB Explorer tree for working with table subobjects (fields, indexes, Foreign keys, etc.), check the Show table subobjects option which is available within the General options group of the Environment Options | DB Explorer page (you can also use the Show Table Subobjects menu item in the drop-down menu of the View Mode toolbar button for the same purpose.)