欢迎您!“一八软件网”是上海趋唯事软件有限公司的在线软件销售和服务网站
PL/SQL Developer
Oracle数据库存储程序单元集成开发环境
  • 产品编号:2013-646
  • 产品类型:开发工具
  • 当前版本:11.0
  • 产品厂商:Allround Automations
概述:有越来越多的商业逻辑和应用逻辑转向了Oracle Server,因此,PL/SQL编程也成了整个开发过程的一个重要组成部分。PL/SQL Developer侧重于易用性、代码品质和生产力,充分发挥Oracle应用程序开发过程中的主要优势。

PL/SQL Developer 11.0 新功能

SQL窗口增强

(1)新增“Compare records”按钮



(2)单条记录模式,SQL窗口能显示列的注释。



(3)SQL窗口其他方面的增强:

  • A Refresh result set button has been added to refresh (re-execute) the result set of the currently selected result tab page
  • Column totals (sum, count, min, max, avg) are now persistent after re-executing a query
  • Added Excel exporter (both xls and xlsx support)
  • Support has been added for Oracle12c extended strings (> 4000 bytes)
  • The align button has a new Hide editor option to show only the result set
  • The align button has a new Window width option to resize the SQL Window width to match the result set width
  • You can now use an AltRowColor=[RRGGBB | name] directive in a comment section of the SQL Window to control the alternate row color
  • You can now use a Records=[all|page|] directive in a comment section of the SQL Window to control the number of initially fetched records
  • You can now use a Totals=[mode:column] directive in a comment section of the SQL Window to display column totals


测试窗口增强

  • 新的debugger按钮:运行到光标行
  • DBMS Output tab page now shows an indicator when output is available
  • Variables can now be sorted by name, type or value
  • Breakpoints form now has a Go to menu item (also double-click). When selected you will be taken to the source location in a Program Window.



编程窗口增强

  • 记忆的代码排序模式
  • 支持不可编辑的程序单元
计划窗口增强
  • Support added for identity columns (Oracle 12c)
  • Support added for "default on null" columns (Oracle 12c)
  • Support added for domain indexes
  • Support added for Logging property of indexes
  • Support added for Validated property of constraints
  • Changing a constraint name will now lead to an "alter table rename constraint" command
  • Changing an index name will now lead to an "alter index rename" command



编辑器增强

  • Column names are highlighted when typing values for an insert or update statement
  • Selection > Uppercase/Lowercase no longer affects quoted text
  • Go to Bookmark now positions bookmark in the centre of the editor

代码帮助器增强

允许选择多个选项


When selecting multiple items or (all), the Code Assistant can place the items on one or multiple lines. A preference allows you to control this behavior. The Code Assistant can additionally align parameter values when selecting multiple items:

替换功能增强
  • New option "lines=" controls number of input lines on the form
  • New option "editor=plain/sql/xml" adds a button that invokes a text editor with the given syntax highlighting
  • New option "lowercase=yes" converts input to lowercase



模板增强

Templates now use the same substitution variable syntax as the SQL Window and Report Window. This adds the following features to the template functionality:
  • Hints
  • Typed variables
  • Hidden variables
  • Required option
  • Uppercase option
  • Lowercase option
  • Descriptive lists
  • Multi-select lists
  • Variable references in queries
The old syntax is still supported for backward compatibility.





回调语句增强
  • You can now select multiple statements
  • The complete statement text can now be expanded/collapsed
  • Semi-colon added when recalling a single SQL statement
  • Recall directory preference now accepts environment variables

连接增强
For each connection you can now define an initialization script that will be executed for each database session that is created for the connection:




测试管理器增强
  • Notes tab page added
  • Added support for LIKE 'VALUE' for output values
  • Added support for IN (VALUE_LIST) for output values
  • Disabled test items are now displayed grayed out in the list



表格导入导出增强
  • User selector added, allowing you to export tables owned by another user.
  • Added support for Oracle12c extended strings (> 4000 bytes)
  • Added Statistics option for the Oracle Export format
  • When exporting in Oracle Export format without rows, statistics will implicitly be excluded




Session窗口增强
  • Support added for HTML text. Click on the cell button of the text to view its contents in an HTML Window.
  • SQL Monitor detail tab page added (Oracle 11.2 and later)
  • Queries in the can now be database version specific




对象浏览器增强

The Object Browser has a new filter field where you can quickly enter filter expressions to limit the browser contents. You can for example enter DEPT% to show only objects that start with DEPT. You can additionally filter on the source text (for PL/SQL objects), status (valid/invalid), creation date and modification date. The filter expression can be entered or modified directly in the filter field above the Object Browser, or you can click on the filter field button to invoke the filter options form. The form has an option to recall the most recently used filters. The example above filters for Valid objects that have the word DeptRecord in the PL/SQL source.

Other enhancements include:
  • Indexes and constraints can now be renamed
  • Triggers can now be created in the context of a table or view
  • Folders added for Primary, Unique and Foreign key constraints for views




Search Bar增强:

A new Search in files option allows you to search on the file system. Results are displayed in the Search List and will be opened in the IDE when clicked. Clicking on the arrow button next to the Search in files button will open the Search file dialog:


Here you can either select one or more locations from the File Browser, select one or more previously defined custom selections, or enter the file selection directly.


窗口列表增强
  • Transaction indicator added for applicable window types
  • Short Text in Window list for database objects shortened
  • Windows are now always displayed in the same order as the Window menu
  • Ctrl-Tab and Ctrl-Shift-Tab now always cycle through the windows in the Window List order



项目管理增强
  • Project folder history preference. When enabled the folder history when opening and saving files is project specific. When disabled, the general history will be used.
  • Project file browser preference. When enabled the project has its own File Browser definitions so that you can easily find project specific files. When disabled, the general File Browser definitions will be used.




预设管理增强

A new Export/Import function allows you to export specific preference sections to a file, and to import them on another PC.

The following preferences options have been added:
  • Files/Format/Encoding: Save with BOM (Unicode Byte Order Mark)
  • User Interface/Options: Maximum recent files
  • User Interface/Code Assistant: Align parameter values\
  • User Interface/Code Assistant: Maximum items on one line
  • User Interface/Appearance: Connection List Sorting (Last used, Database, Username, Display name)
  • Oracle/Logon History: Delete all items button added
  • Tools/Recall Statement: Directory name now supports environment variables




其他IDE增强
  • Full screen mode will now show minimized docking tools so that they can still be accessed
  • 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 associated with that file
  • The logon form now has shortcuts for all fields, is sizeable to show long database names in the selection list
  • For multi-monitor configurations the form positions will now be stored and restored per monitor
  • Crash recovery and desktop files now saved in the user's Application Data directory instead of the Temp directory
  • Command-line parameter NoLoadDesktop added to prevent loading layout on startup
  • Command-line parameter InstanceName added to identify different instances for storing form positions
其他增强
  • Compare User Objects, Export User Objects and Compare Table Data now allow you to select a user after startup or connection change
  • Compile Invalid Objects no longer implicitly refreshes the object list when the main connection is changed
  • Copy function added to the Search List popup menu
  • Refresh function added to the File Browser popup menu


--------------------------------------------------------------------



强大的PL/SQL编辑器
利用它的语法高亮、SQL和PL/SQL帮助、对象描述、代码帮助、编译器提示、重构、PL/ SQL美化、代码编目,代码层次化、超链导航、宏库等大量有用的功能,以及Unicode兼容的编辑器吸引着苛刻要求的用户。当你需要时,或最多点击一次,信息将自动呈现给你。



集成调试器
集成的调试器提供所有你希望得到的功能:Step In,Step Over,Step Out,Run Until Exception,Breakpoints,浏览和设置变量,浏览调用Stack等。你能够调试任何的程序直到不需要再修改,包括触发器和对象类型。



流程图
流程图窗口将允许你创建一个选择对象的图形表示。这个方法使你能够轻松可视化数据库应用的对象或项目和它们的依赖关系。流程图能够用于编写你的文档,而且还能保存为一个工作空间。右键点击对象访问所有对象的功能,双击一个对象将调用对象类型的缺省动作。


  • 强大的SQL和PL/SQL开发环境
  • 支持代码美化
  • 支持回归测试
  • 支持Schema和数据比较
  • 分享到:
  • 上海趋唯事软件有限公司
    销售:021 - 3211 0920
    技术:021 - 3211 0930
    邮件:sales(#)commuch.com
联系我们: 021 - 3211 0920 , 3211 0930