<1> Tools-Preferences-User Interface-Options，在窗口中选中“Autosave Desktop”，
然后拖拽Window List到目标位置上，下次启动PLSQL Developer，就可以看到锁定效果 了。
<2> 要保存当前一些窗口的模式，在你调整好窗口布局后，选择菜单Window->Save Layout 就可以了
<3> 保存密码: tools->Preferences->Oracle->Logon History，“Store history”是默认勾选的，勾上“Store with password”即 可
<4>格式化SQL语句 选中需要格式化的SQL语句，然后点击工具栏的Edite --- PL/SQLbeautifier 按钮即可
<5> tools -- Browser Filters 设置默认的 my Object
<6>查看执行计划
在使用PL/SQL Developer的SQL Window时，有时候输入的SQL语句执行的效率，分析下表结构，如何可以提高查询的效率，可以通过查看Oracle提供的执行计划；
使用方法：选中需要分析的SQL语句，然后点击工具栏的Explain plan按钮（即执行计划），或者直接按F5即可
相关推荐
PL/SQL Developer 是一款强大的集成开发环境，专门用于编写、调试和管理 PL/SQL 代码。以下是一些关于 PL/SQL Developer 的常用设置和功能的详细说明： 1. **代码提示设置**： - 手动提示：在 `Tools` 菜单中选择 ...
Debugger "Execute SQL" function did not show a result set for a WITH statement Execution in a Command Window did not immediately enable the Break button Recently used file list did not work correctly ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
PL/SQL Developer允许用户自定义快捷键，如为常用操作分配ALT+S和ALT+C给SQL Window和Command Window，以提高工作效率。 7. **其他实用功能**： - 快速清空表：在对象上右键选择`Truncate Table`。 - 分析与验证...
PL/SQL Developer 13.0 - New Features Enhancements Language packs added for Brazilian, Chinese, French, German, Hungarian, Japanese, Russian and Spanish Performance and stability improvements ...
PL/SQL Developer 提供了多种窗口来辅助开发工作，包括 SQL Window、Command Window 和 Program Window 等。这些窗口各有其特色和用途： - **SQL Window**：用于编写和执行 SQL 语句。 - **Command Window**：可以...
Enhancements in PL/SQL Developer 12.0.7 ======================================= * Find & Replace functions in did not work in a Macro * Compile referencing objects did not show all invalid objects * ...
Window List did not conform to the “Short Text” setting for Difference Viewer windows The Difference Viewer window did not always have a correct title Cut and Paste did not work in the SQL Window in...
15. 窗口大小调整：利用`SET_WINDOW_PROPERTY(window_name,PROPERTY_SIZE,WINDOW_SIZE.MAXIMIZE)`等方法，可以使FORM在运行时自动最大化或最小化。 以上这些技巧和解决方案是Oracle Forms开发中常用的技术，熟练...
Connection popup menu item "New Instance" added to open a new PL/SQL Developer instance for the selected connection When the read-only status of a file changes this will be propagated to a window ...
Window icons now indicate the PL/SQL Developer window type. Connection status icon moved to the left for consistency. Session Window enhancements You can now define Session Actions that can be ...
通过**Tools -> windowlist**菜单，用户可以调出窗口列表视图，并将其放置于界面的任何位置，如左下角。这一特性有助于多任务处理，使用户能够同时监控多个窗口或查询结果，提高工作效率。此外，**Window -> save ...
* PL/SQL Developer main window could not always be minimized * To-Do list would not always be updated when switching editors in a Program Window * Case expressions could cause incorrect "Unused ...
Connecting the PL/SQL Developer main connection from the Command Window would show "Not logged on" as feedback File Dialog and Find Dialog could incorrectly show up after unlocking Windows An error ...
Connecting the PL/SQL Developer main connection from the Command Window would show "Not logged on" as feedback File Dialog and Find Dialog could incorrectly show up after unlocking Windows An error ...
when docking a notebook) the PL/SQL Developer Window would be restored when minimized, and the minimize button did not work Text Importer field selection list size optimized + pre-select next field ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...
On the "View" ribbon you can now choose between a Single Document Interface (SDI) or Multiple Document Interface (MDI - the same as in PL/SQL Developer 11.0 and earlier). In SDI mode you always see ...