|
PL/SQL Developer 是一款集成开发环境，用于开发、测试、调试和优化 Oracle PL/SQL 存储的程序单元，如包、触发器等。 PL/SQL Developer 的功能包括上下文相关帮助和数据库对象描述、语法加亮、数据查询和编辑、图形浏览器等，这些功能使开发人员的工作更为轻松。 档案大小:103mb PL/SQL Developer是一个集成开发环境，专门针对Oracle数据库的存储程序单元的开发。随着时间的推移，我们看到越来越多的业务逻辑和应用程序逻辑转移到Oracle服务器，因此PL/SQL编程已经成为整个开发过程的重要部分。PL/SQL Developer关注于易用性、代码质量和生产力，这些是Oracle应用程序开发过程中的关键优势。 以下是PL/SQL Developer的主要特性: 强大的PL / SQL编辑器 语法高亮显示、SQL和PL/SQL帮助、对象描述、代码助手、编译器提示、重构、PL/SQL美化器、代码内容、代码层次、代码折叠、超链接导航、宏库和许多其他复杂的特性，Unicode兼容编辑器甚至会吸引最苛刻的用户。当你需要信息时，信息会自动呈现给你，或者最多只需点击一下鼠标。 集成调试器 集成调试器提供了您希望的所有特性:单步调试、单步调试、单步调试、运行直到异常、断点、视图和设置变量、视图调用堆栈等等。您可以调试任何程序单元，而无需对其进行任何修改，包括触发器和对象类型。 PL / SQL美化者 PL/SQL美化器允许您通过一组用户定义的规则格式化SQL和PL/SQL代码。您的代码可以在编译、保存或打开文件时自动美化。如果您在大型项目团队中工作，此特性将提高您的编码效率，并提高PL/SQL代码的可读性。 SQL窗口 SQL窗口允许您输入任何SQL语句或多条语句，并在网格中查看或编辑结果。结果网格支持示例查询模式，以搜索结果集中的特定记录。您可以轻松地从历史缓冲区中召回以前执行的SQL语句。SQL编辑器提供了与PL/SQL编辑器相同的强大功能。 命令窗口 要开发和执行SQL脚本，可以使用PL/SQL Developer的命令窗口。这个窗口具有与SQL*Plus相同的外观，另外还有一个内置的脚本编辑器，具有相应的语法高亮显示。现在，您可以在不需要“编辑脚本/保存脚本/切换到SQL*Plus /运行脚本”周期的情况下开发脚本，并且不需要离开舒适的PL/SQL开发IDE。 报告 要针对应用程序数据或Oracle字典运行报表，可以使用PL/SQL Developer的内置报表功能。有许多标准的报告，您可以轻松地创建自己的自定义报告。这些自定义报表可以保存在报表文件中，报表文件又可以包含在报表菜单中。这使得运行您自己的经常使用的自定义报告非常容易。 图 Diagram窗口允许您为选择的对象创建图形表示。通过这种方式，您可以轻松地将应用程序或项目的数据库对象及其关系可视化(一部分)。图可以用于文档的目的，也可以作为工作空间。右击对象提供对所有对象函数的访问，双击对象将调用对象类型的默认操作。 项目 要组织工作，可以使用PL/SQL Developer的内置项目概念。项目由源文件、数据库对象、注释和选项组成。它允许您在特定的项目集范围内工作，而不是在完整的数据库或模式范围内工作。这使得查找所需的项目项、编译所有项目项或将项目从一个位置或数据库移动到另一个位置变得很容易。 回归测试 对于回归测试，可以使用PL/SQL Developer的内置测试管理器。您可以定义和运行测试集，并快速确定所有测试是否正确运行。如果出现错误，测试管理器可以启动调试器来调查错误的原因。您可以从命令窗口运行测试集来进行自动回归测试。 任务物品 您可以在任何SQL或PL/SQL源文件中使用to - do项来快速记录源文件中需要完成的工作。稍后您可以在对象级别或项目级别从待办事项列表中访问此信息。
File size: 103 MB PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.
The following are major features of PL/SQL Developer:
Powerful PL/SQL Editor
With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user. Information is automatically presented to you when you need it, or is at most one click away. Integrated Debugger
The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it, including triggers and object types. PL/SQL Beautifier
The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams. SQL Window
The SQL Window allows you to enter any SQL statement or multiple statements and view or edit the results in a grid. The result grid supports a Query By Example mode to search specific records in a result set. You can easily recall previously executed SQL statements from a history buffer. The SQL editor provides the same powerful features as the PL/SQL Editor. Command Window
To develop and execute SQL scripts you can use PL/SQL Developer's Command Window. This window has the same look and feel as SQL*Plus, and additionally has a built-in script editor with corresponding syntax highlighting. Now you can develop your scripts without the "edit script / save it / switch to SQL*Plus / run script" cycle, and without leaving the comfortable PL/SQL Developer IDE. Reports
To run reports against your application data or against the Oracle dictionary, you can use PL/SQL Developer's built-in Report functionality. There are a number of standard reports, and you can easily create your own custom reports. These custom reports can be saved in a report file, which can in turn be included in the reports menu. This makes it very easy to run your own frequently used custom reports. Diagrams
The Diagram Window allows you to create a graphical representation of a selection of objects. This way you can easily visualize (a part of) the database objects of your application or project and their relations. A diagram can be used for documentation purposes, but can also serve as a workspace. Right-clicking on an object provides access to all object functions, and double-clicking on an object will invoke the default action for the object type. Projects
To organize your work you can use PL/SQL Developer's built-in project concept. A project consists of a collection of source files, database objects, notes, and options. It allows you to work within the scope of a specific set of items, instead of a complete database or schema. This makes it easy to find the project items you need, to compile all project items, or to move a project from one location or database to another. Regression Testing
For regression testing you can use PL/SQL Developer's built-in Test Manager. You can define and run a Test Set, and quickly determine if all tests run correctly. In case of an error, the Test Manager can launch the Debugger to investigate the cause of the error. You can run Test Sets from the Command Window for automated regression testing. To-Do Items
You can use To-Do Items in any SQL or PL/SQL source file to make a quick note that something needs to be done in this source file. You can access this information later from the To-Do List, either at the object level or at the project level.
Download 百度网盘
| 
发表于 2020-6-11 18:42:23
