Object Tree

The Object Tree gives you a visual, tree-structured view of every object in your connected Oracle schema — from tables and views to packages, procedures, functions, triggers, and sequences.

Opening the Object Tree

The Object Tree lives in the Connections Explorer sidebar. Expand a connection node to reveal the object type folders:

• 📁 Tables
• 📁 Views
• 📁 Packages
• 📁 Procedures
• 📁 Functions
• 📁 Triggers
• 📁 Sequences
• 📁 Types
• 📁 Synonyms
• 📁 Database Links

Expand any folder to see the individual objects.

Searching & Filtering

Use the search icon (🔍) in the Connections Explorer toolbar to filter objects by name. The filter applies across all object types simultaneously.

Type: EMPLOYEES
Finds: EMPLOYEES (table), EMPLOYEES_SEQ (sequence), etc.

The filter is cleared when you close the search box.

Go to Definition

Double-click any object in the tree to open its DDL in an edit block — or use Go to Definition (F12) from any symbol reference in a SQL/PL/SQL editor.

Object Details and Actions

Right-click an object and choose View Object Details to open a webview panel showing:

• Full DDL source
• Column list (for tables/views)
• Grants and privileges
• Dependent objects and related metadata where Oracle exposes it

Rename & Refactor

Right-click a supported object and choose Rename. Nexo SQL Studio prepares the Oracle rename operation and prompts before execution.

Refreshing the Tree

Refresh manually with the Refresh icon in the toolbar or by right-clicking a node and choosing Refresh.

Cross-Schema Browsing

You can browse objects in other schemas by expanding the Other Schemas node at the bottom of the tree. Your user must have the necessary SELECT ANY or SELECT_CATALOG_ROLE privileges.