当前位置:网站首页>Common settings of PLSQL developer

Common settings of PLSQL developer

2020-11-09 22:20:35 Calm wind and clouds

[TOC]

Display configuration

My objects To the top

  • Tools→User Interface→Object Brower→Filters, hold My objects To the top

Tables To the top

  • Tools→User Interface→Object Brower→Folders, hold Tables To the top

Database connection configuration

Log out of default and roll back

  • Tools→Preferences→Oracle→Connection, Logoff with open transacation, choose Rollback;

Check connections

  • Tools→Preferences→Oracle→Connection, Check connnection, Check ;

Save login information

  • Tools→Preferences→Oracle→Logon History, Store history It is checked by default , Check again Store with password, Log in again and enter the password once and remember

Query configuration

Statement automatic selection

  • The one where the mouse is SQL sentence , That is to execute the current SQL sentence
  • Tools→Preferences→Window types→SQL Window, AutoSelect Statement

Statement execution hotkey ( Optional )

  • Then press Ctrl+Enter, Change the default execution shortcut key F8 by Ctrl+Enter( similar toad)
  • Tools→Preferences→Key Configuration→Session/Execute

Format configuration

Keywords are automatically capitalized

  • Tools→Preferences→Editor→Keyword case, choice Uppercase

Keywords are automatically capitalized , Everyone should develop a coding habit of their own , And keep it going

Display configuration

Numeric type - String format display

  • Tools→Preferences→Window types→SQL Window, Number fields to_char, Check ;

The date type V1 - String format display

  • Tools→Preferences→Window types→SQL Window, Date fields to_char, Check ;

The query date format cannot be customized display

The date type V2 - String format display ( Customize )

Get rid of Date use to_char Check for conversion

  • Tools→Preferences→Window types→SQL Window, Date fields to_char, Don't check ;

Customize the date format

  • Tools→User Interface→NLS Options, among :
  • Date Set to : yyyy-MM-dd
  • Time Set to : HH:mm:ss

SQL Windows List Show

Keep the last open SQL Script

  • Tools→User Interface→Options→Autosave desktop

Show the full path of the file

  • Tools→User Interface→Options→Show complete file path in windows titles

版权声明
本文为[Calm wind and clouds]所创,转载请带上原文链接,感谢