12/17/2023 0 Comments Oracle sql developer shortcut keysThe core of the information system is the database. It is a good habit to write SQL statements in uppercase. You can double-click and drag and drop the mouse to bind the required event, for example, double-click to edit the data, drag and drop to display the table structure, Yeah! Setting Method: choose Tools> Preferences> Browser to bind double-click and drag-and-drop operations to different Object types on the right. double-clicking the table data and double-clicking the table or view shows the default response, which disappoint me, because I am most concerned about the table structure and data, but these two things did not happen after double-clicking, maybe the default response is required by experts, but for me, viewing data and table structure is the most important thing, I don't care about others. Setting method: menu Tools -> Preferences -> Oracle -> Logon History -> Store With Password 3. Therefore, PLSQL Developer can remember the password. However, if the password is the same as the user name in the development database, it makes no sense to enter the password each time. Remember the password is a controversial feature, Because remembering the password will bring data security issues. ![]() Tools menu-Brower Folders: Move the directories you frequently clicked (for example, Tables Views Seq Functions Procedures) to a higher level and add colors to differentiate them, in this way, the average table searching time will be greatly shortened. The order window of Brower Folders is opened and "My Objects" is set to the default one. Setting Method: Tools menu -> Brower Filters. If the user you log on to is dba, expand the tables directory, in normal cases, Wait takes several seconds, and the response speed after selecting My Objects is calculated in milliseconds. By default, after PLSQL Developer logs on, All objects is selected in Brower. After logon, My Objects is automatically selected by default. We understand that these settings can be used more efficiently by using Oracle databases, next let's take a look at this part.ġ. In Oracle databases, the PL/SQL shortcut setting method is what we will introduce in this article. ![]() Move to begin or end of the quick info window.This document describes how to set the shortcut keys for PL/SQL in Oracle databases, this includes setting My Objects, remembering the password, and double-clicking to display table data by default after logon. Move to begin or end of the visible search results in the grid. Global settings dialog box TO DO THISĭefault project settings dialog box TO DO THISĮnd-user license agreement dialog box TO DO THISĬopy the entire EULA text to the clipboard. To access Context menu for the selected object in Object explorer, the keyboard shortcut used is SHIFT + F10 or Apps key. TO DO THISĭisplay about SSMA for Oracle dialog box.ĭisplay customer feedback options dialog box. The following table describes the keyboard shortcuts used to access menu items under Help menu. To access Help menu, the keyboard shortcut used is ALT + H. TO DO THISĭisplay the repository of test cases dialog box.ĭisplay the repository of test results dialog box.ĭisplay add tables to backup for Oracle dialog.ĭisplay restore tables from backup for Oracle dialog.ĭisplay manage backup contents for Oracle dialog.Īccess SQL Server backup management submenu.ĭisplay add tables to backup for SQL Server dialog.ĭisplay restore tables from backup for SQL Server dialog.ĭisplay manage backup contents for SQL Server dialog. The following table describes the keyboard shortcuts used to access menu items under Tester menu. To access Tester menu, the keyboard shortcut used is ALT + S. Synchronize with SQL Server or Azure SQL Database.ĭisplay the default project settings dialog box. The following table describes the keyboard shortcuts used to access menu items under Tools menu. To access Tools menu, the keyboard shortcut used is ALT + T. The following table describes the keyboard shortcuts used to access menu items under View menu. To access View menu, the keyboard shortcut used is ALT + V. Paste the most recently added text from the clipboard. The following table describes the keyboard shortcuts used to access menu items under Edit menu. ![]() To access Edit menu, the keyboard shortcut used is ALT + E. TO DO THISĭisplay the connect or reconnect to Oracle dialog box.ĭisplay the connect or reconnect to SQL Server or SQL Azure dialog box. ![]() The following table describes the keyboard shortcuts used to access menu items under File menu. To access File menu, the keyboard shortcut used is ALT + F. The following sections describe the keyboard shortcuts to access menu commands and other shortcut keys used in various dialog boxes of SSMA for Oracle application.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |