PL/SQL usage habits

Source: Internet
Author: User

PL/SQL usage habits 1. After logging on, the My Objects Tools menu -- Brower Filters will be automatically selected by default. The order window of Brower Filters will be opened and "My Objects" will be set to the default one. 2. when PL/SQL is opened, there is no Window List by default (Window List), you need to manually click a few menus, in fact, after opening the Window List and dragging and arranging the location, click "window" and save the layout (S). The style will be retained later. for some other settings picked on the internet, mark 1 first. You can move the directories (for example, tables Views Seq Functions Procedures) You frequently clicked to the Tools menu-Brower Filters to a higher level, and add the color differentiation, so that your average table searching time will be greatly shortened. Try again. 2. Remember the password? Setting Method: Tools menu -- Preferences -- Oracle -- Logon HIstory -- Store with password 3. Double-click to display table data? Setting Method: Preferences -- User Interface. On the right side, bind double-click and drag-and-drop operations for different Object types. 4. Special Copy? The SQL statements written in the SQL Window usually need to be placed in Java or other languages, and you need to convert them into strings and add the corresponding hyphens. This does not need to be repeated, right-click the prepared SQL statement and use the special Copy function! 5. What statements are automatically selected in the SQL Window Based on the cursor position? Setting Method: Preferences -- Window Types -- SQL Window. Select AutoSelect statement. Note that each statement must be followed by a plus sign. 6. Highlight Preferences -- User Interface -- Editor -- other -- Highlight edit line in the selected row.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.