The metadata tree in the Connections pane displays all the objects (categorized by object type) accessible to the defined connections. To have such tables included in the display, clear the filter. Note that for tables, the initial default node label is Tables (Filtered), to reflect the exclusion of tables that are in the Recycle Bin. To remove the effects of applying a filter, right-click the node and select Clear Filter. For example, you can right-click the Tables node and specify a filter of EM% to see only tables that start with EM and to have the Tables node label be changed to Tables (EM%). Refresh queries the database for the current details about the selected object (for example, a connection or just a table).Īpply Filter restricts the display of objects using a filter that you specify. Icons above the Connections node and metadata tree perform the following actions on the currently selected object: The Reports navigator (not shown in the preceding figure) lists informative reports provided by SQL Developer, such as a list of tables without primary keys for each database connection, as well as any user-defined reports. The Files navigator is especially useful if you are using versioning with SQL Developer. sql file, it is displayed in a SQL Worksheet window. You can double-click or drag and drop files to open them, and you can edit and save the files. The Files navigator (marked by a folder icon not shown in the preceding figure) displays your local file system using a standard hierarchy of folders and files. To create a new database connection, import an XML file with connection definitions, or export or edit current connections, right-click the Connections node and select the appropriate menu item. The Connections navigator lists database connections that have been created. The left side of the SQL Developer window has panes for the Connections and Reports navigators (any other navigators that you might open), icons for performing actions, and a hierarchical tree display for the currently selected navigator, as shown in the following figure.ĭescription of the illustration ui_left.gif To undo any main toolbar customization, select Reset Toolbars. However, you can add and remove main toolbar icons by clicking View, Show Toolbars, Customize Main Toolbar, then choosing desired options. If you do not use the drop-down arrow to specify the database connection to use, you are asked to select a connection.
Open SQL Worksheet opens the SQL Worksheet. (Or use the drop-down arrow to specify a tab view.) (Or use the drop-down arrow to specify a tab view.)įorward moves to the pane after the current one in the list of visited panes. Save All saves any changes to all open objects.īack moves to the pane that you most recently visited.
Save saves any changes to the currently selected object. The main toolbar (under the menus) contains Icons to perform various actions, which by default include the following: To close a window that has focus (such as the SQL Developer main window, a wizard or dialog box, or the Help Center) and any of its dependent windows, you can press Alt+F4. You can also display the File menu by pressing the F10 key (except in the SQL Worksheet, where F10 is the shortcut for Explain Plan). You can use shortcut keys to access menus and menu items: for example Alt+F for the File menu and Alt+E for the Edit menu or Alt+H, then Alt+S for Help, then Search. Oracle TimesTen In-Memory Database Supportĭescription of the illustration ui_top.gif Running and Debugging Functions and ProceduresĪpache Hadoop Connectors Support in SQL Developer Installing and Getting Started with SQL Developer This topic includes the following topics:
#Affinity photo 1.7.2 product key how to#
This topic covers the main Oracle SQL Developer concepts, and explains how to use the major SQL Developer features.
0 kommentar(er)
