DB Explorer
Find and open objects.
| Icon | Tool Tip | Description |
|---|---|---|
 |
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:
|
Describe
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. |
| Icon | Tool Tip | Description |
|---|---|---|
|
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. |
History
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.
Button Description 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.
Dependencies
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. |