Make your PL/SQL easier to use

It makes PL/SQL easier to use. all SQL statement characters are capitalized. The core of the information system is the database. When a system goes wrong, the first query is the SQL statement, how to quickly find the SQL statement in the vast log is quite painful. SQL statements in uppercase cannot completely solve this problem, but it is easier to find a line of all uppercase characters in the middle of a pile of code. Thank you in your eyes. Setting Method: menu Tools> Preferences> Editor> Keyword Case> Uppercase 2. in SQL Window, the statement setting method is automatically selected based on the cursor position: Tools --> Preferences --> Window Types --> SQL Window. Select AutoSelect statement. Note that each statement must be followed by a plus sign. III. custom shortcut Key setting method: menu Tools --> Preferences --> Key Configuration find the shortcut Key you want to set, you can directly operate on the keyboard. set comparison: Before not set: run the statement as, select the statement to be executed, and then press the default shortcut key F8. set the SQL Window to automatically select the statement based on the cursor position and then customize the shortcut key, you can perform related operations. after setting operation: Execute the statement to move the cursor to the position of the statement to be executed, and then press the corresponding shortcut key. the procedure is as follows: 1 .) in SQL Window, the statements Preferences --> Window Types --> SQL Window are automatically selected based on the cursor position. Select AutoSelect statement 2 .) custom shortcut Tools --> Preferences --> Key Configuration find the shortcut Key you want to set and perform keyboard operations directly, for example, shift + Enter. execute the statement when setting this shortcut key. other settings: Set the font: Tools --> Preferences --> set the font color: menu Tools --> Preferences --> Editor remembers the password setting method: menu Tools> Preferences> Oracle> Logon History> Store With Password