Find and open objects.
 |
Refresh |
Refresh the tree data.
Use if you have created new objects that are not visible in the tree yet. |
| |
Name Filter |
Type in a filter phrase (for example c% to filter all objects with names starting with c). |
 |
Upper case filter |
Click to toggle between Upper case filter and Mixed case filter.
The upper case filter is selected by default. Use the mixed case filter to find objects with names that are mixed case, lower case or have special characters. |
 |
Filter |
Open the Filter Properties dialog. Filter Properties Dialog |
DB Explorer is similar appearance to DB Navigator. DB Explorer is a light version of DB Navigator, integrated into the Code Editor for extra convenience.
|
|
TIP:
- Expand the tree nodes to display the filtered objects.
- Drag and drop objects from DB Explorer into the Code Editor.
- Set the behavior of dragging and dropping table names from View | Preferences | Code Editor | SQL Scripts | Drag & Drop.
|
Show the data structure for tables, indexes, views and synonyms.
|
|
Note: To increase response time, the drop down list is not populated with objects when the tool is first activated. |
| |
Filter |
To show the complete list, leave the Filter blank and press Enter.
You can use wildcards to filter the objects. For example, type t% and press Enter to display only objects with names starting with "t". Select an object from the list to show its column names and types. |
 |
Quick Browse |
View the chained rows information as per Object Menu | Quick Browse.
Select the object to Describe.
The results show in SQL Query Results Data Grid. |
 |
Edit Data |
Edit data in a table object as per Object Menu | Edit Data.
Select the object to Describe.
The results show in SQL Query Results Data Grid.
The Edit Data command executes an Updateable query. |
The History tool lists successfully executed SELECT, UPDATE, DELETE commands and PL/SQL blocks up to 1000 of the most recent ones in the current session. In the History window, each SQL statement is accompanied with the date, time and the schema that they were executed on.
You can easily recall the most recent SQL statements that have been executed in the current session.
-
Select the statement you want to recall.
|
|
TIP: You can press Ctrl+up arrow to move back in the sequence, and Ctrl + down arrow to move forward. |
-
Take action.
| New Tab |
Open a new Code Editor tab and paste the statement into it. |
| Insert |
Add the recalled statement to the current contents. |
| Replace |
Replace the current contents of the editing window with the selected SQL statement. |
| Clipboard |
Copy the statement to the clipboard, ready to paste the statement into another location. |
| Delete |
Drop the statement from the SQL History list. |
| Double Click... |
Select an action (New Tab, Insert, Replace or Clipboard) that will be executed on double-clicking an entry in History. |
|
|
TIP: You can also insert the statements by dragging and dropping them into the Code Editor. |
Lists the Dependants and Depends On objects of the current script.
|
|
Note: Objects with a large amount of dependant and depends on objects will take more time to load. To improve the performance, hide this pane when opening those objects. |
|
|
TIP: Right click over the Dependents or Depends On lists to view available commands to manipulate objects in the lists. |
