Plsql Developer settings and shortcut key settings

1, default automatically check my Objects by default, plsql developer login, Brower will select all Objects, if you are logged in the user is a DBA, to expand the tables directory, the normal situation will need to wait a few seconds, The response rate after selecting my objects is measured in milliseconds. Setup method: Tools Menu-Brower Filters will open the Order window for Brower folders and set "My Objects" to default. Tools menu--brower Folders, put a few directories you often order (such as: Tables views Seq Functions Procedures) Move up a bit, and add color to distinguish, so your average time to find the table will be greatly shortened, try. 2, remember passwords This is a controversial feature, because remembering passwords can be a problem for data security. But if it is the development of the library, the password can even be the same as the user name, each time to enter a password is meaningless, you can consider let Plsql developer remember the password. Setup method: Menu Tools---Preferences----Oracle---Logon history--Store with Password3, double-click to display table data The default response to the mouse double-clicking a table or view is disappointing because I am most concerned with the table structure and data, but the two things do not happen after double-clicking, perhaps the default response is the master needs, but for me to view the data and table structure is the most important, other I do not care. But the good thing is this can be set, you can give the mouse double-click and drag and drop the required events, such as: Double-click Edit Data, drag and drop display table structure, yeah! Setup method: Menu Tools--PreferencesBrowser, on the right, binds double-click and drag-and-drop operations for different object type. 4, SQL statement characters all uppercase self think this is a good habit, the core of the information system is the database, the first thing to check when the system problem is the SQL statement, how to quickly find the vast log of the SQL statement is a more painful thing.   SQL statement capitalization does not solve this problem completely, but finding a line of all uppercase characters in the middle of a heap of code is relatively easy, and your eyes will thank you. Setup method: Menu Tools--Preferences----Keyword case----Uppercase5, Special Copy in SQL window to write SQL statements usually need to put in Java or other languages, you need to turn into a string and add the corresponding hyphen, this thing does not need to repeat, in the written SQL right-click, using special copy is ok! Setting method: Right mouse button-Special Copy6, custom shortcut keys Plsql Developer has a lot of keys reserved for users to customize, this is a very hight thing. Unlike the overbearing word, basically all the keys have been pre-defined features, the change is very headache. Normally, when you open Plsql developer, the most common thing to do is to open the SQL window and Command window and define the shortcut keys for the two operations, ALT+s and ALT +C, so take the mouse point three things only need to press the key. Setup method: Menu Tools--PreferencesKey Configuration7, SQL window automatically selects the statement setting method according to the cursor position: Preferences--Window Types--SQL Window, select AutoSelect statement. Notice that you add a semicolon after each statement. Add:8, start plsql developer,window list Menu Auto-call requires two-step setup, first to save the desktop settings, and then tick the window list option, the following: A, Select option in the user interface in the Preference option under Tools for menu items, and in the AutoSave desktop on the right, check the box above. B. The window list option is checked under Tools in the menu item. 9, formatted SQL (format) when you get a long SQL statement, you want to quickly see the logic, you can put it in this tool, format, the logic of the statement is clear10, the database automatically detects the connection situation because the database does not operate for a period of time, it will automatically disconnect, and then need to manually connect, because the network reason, always stuck there. The tool provides the ability to detect connections, which can be automatically connected. Specific settings in Tools-preferences-Check Connection,check Connection in front of the check box. 11, commonly used shortcut keys in fact, these are mentioned in the 6th item, here is my custom settings: Ctrl+tab Switch Windows window (or alt+left/right)alt+n Create a new SQL windowALT+c Close the current window Alt+f format Sqlalt+End lists all results shift+ESC stops running12Automatically replace the shortcut input SQL statement, such as enter S, press the space, automatically replace the select; for example, enter SF, press space, automatically replace with select*from, very convenient, save a lot of time to write duplicate SQL statements. Setting method: Menu tools–> preferences–> editor–> autoreplace. –>edit below defines some rules as reference s=SELECT F=From W=WHERE o=ORDER by D=DELETE SF=select *From DF=DELETE from SC=select COUNT (*) from

Plsql Developer settings and shortcut key settings